APPS.PSP_ER_WORKFLOW dependencies on PAY_PAYROLL_ACTIONS

Line 71: from pay_payroll_actions

67: /* Main Procedure */
68: procedure pyugen_er_workflow(pactid in number) as
69: cursor get_request_id is
70: select request_id
71: from pay_payroll_actions
72: where pactid = payroll_action_id;
73: l_request_id number;
74:
75: CURSOR orig_request_id_cur IS

Line 78: pay_payroll_actions paa

74:
75: CURSOR orig_request_id_cur IS
76: SELECT paa.request_id
77: FROM fnd_concurrent_requests fcr,
78: pay_payroll_actions paa
79: WHERE fcr.request_id = l_request_id
80: AND paa.payroll_action_id = TO_NUMBER(fcr.argument2);
81:
82: CURSOR conc_program_name_cur IS

Line 127: (select 1 from pay_payroll_actions where payroll_action_id =pactid and action_status

123:
124: -- Moved teh deletion of temporary table to submit and Purge code paths.
125: /* Following statement added to purge psp_selected_persons_t in dinit code, when run is successful * /
126: DELETE from psp_selected_persons_t WHERE request_id=l_request_id and not exists
127: (select 1 from pay_payroll_actions where payroll_action_id =pactid and action_status
128: ='E') ;
129: -- End of comment *****/
130:
131: EXCEPTION

Line 1773: FROM pay_payroll_actions

1769: AND xtt.application_short_name = 'PSP';
1770:
1771: CURSOR payroll_action_id_cur IS
1772: SELECT payroll_action_id
1773: FROM pay_payroll_actions
1774: WHERE request_id = p_request_id;
1775:
1776: l_arg1 VARCHAR2(100);
1777: l_arg2 VARCHAR2(100);