BIP HCM Payroll - Is there any alternative to pull the Payroll process status
BIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query
/* (
SELECT meaning
FROM hcm_lookups
WHERE lookup_type = 'ORA_HWM_PAY_PROC'
AND lookup_code = (
CASE
WHEN pay_interface_time.Get_payroll_process_status(tm_trec.tm_rec_row_id, NULL, NULL) = 'PROCESSED' THEN 'ORA_HWM_PAY_PROC_COMP'
ELSE 'ORA_HWM_PAY_PROC_NONE'
END
)
) AS pay_proc_status */
By using the following pay_interface_time.Get_payroll_process_status PL/SQL function, we are facing lot of Performnace issue.
Thanks