12:
13: SELECT payroll_action_id
14: INTO l_payroll_action_id
15: FROM pay_payroll_actions ppa,
16: fnd_conc_req_summary_v fcrs,
17: fnd_conc_req_summary_v fcrs1
18: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
19: AND fcrs.priority_request_id = fcrs1.priority_request_id
20: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
13: SELECT payroll_action_id
14: INTO l_payroll_action_id
15: FROM pay_payroll_actions ppa,
16: fnd_conc_req_summary_v fcrs,
17: fnd_conc_req_summary_v fcrs1
18: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
19: AND fcrs.priority_request_id = fcrs1.priority_request_id
20: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
21: AND ppa.request_id = fcrs1.request_id;