52:
53: SELECT payroll_action_id
54: INTO l_payroll_action_id
55: FROM pay_payroll_actions ppa,
56: fnd_conc_req_summary_v fcrs,
57: fnd_conc_req_summary_v fcrs1
58: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
59: AND fcrs.priority_request_id = fcrs1.priority_request_id
60: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
53: SELECT payroll_action_id
54: INTO l_payroll_action_id
55: FROM pay_payroll_actions ppa,
56: fnd_conc_req_summary_v fcrs,
57: fnd_conc_req_summary_v fcrs1
58: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
59: AND fcrs.priority_request_id = fcrs1.priority_request_id
60: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
61: AND ppa.request_id = fcrs1.request_id;