DBA Data[Home] [Help]

APPS.PAY_EOSURVEY_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 673: /* This cursor picks up the max of asact_id which has been locked in pay_action_interlocks.

669: FROM pay_assignment_actions
670: WHERE payroll_action_id = l_pactid
671: AND chunk_number = l_chunk;
672:
673: /* This cursor picks up the max of asact_id which has been locked in pay_action_interlocks.
674: this was selected during action creation. */
675:
676: CURSOR c_max_asact_id(l_locking_asact_id pay_assignment_actions.assignment_action_id%type)
677: IS

Line 679: FROM pay_action_interlocks

675:
676: CURSOR c_max_asact_id(l_locking_asact_id pay_assignment_actions.assignment_action_id%type)
677: IS
678: SELECT locked_action_id
679: FROM pay_action_interlocks
680: WHERE locking_action_id = l_locking_asact_id;
681:
682: /* This cursor selects the person information like race, job_category only for employees
683: and EMP_APL. */