1965: INTO l_payroll_action_id
1966: FROM pay_payroll_actions ppa
1967: , fnd_conc_req_summary_v fcrs
1968: , fnd_conc_req_summary_v fcrs1
1969: WHERE fcrs.request_id = fnd_global.conc_request_id
1970: AND fcrs.priority_request_id = fcrs1.priority_request_id
1971: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id
1972: AND ppa.request_id = fcrs1.request_id;
1973: EXCEPTION
2250: INTO l_payroll_action_id
2251: FROM pay_payroll_actions ppa,
2252: fnd_conc_req_summary_v fcrs,
2253: fnd_conc_req_summary_v fcrs1
2254: WHERE fcrs.request_id = fnd_global.conc_request_id
2255: AND fcrs.priority_request_id = fcrs1.priority_request_id
2256: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
2257: AND ppa.request_id = fcrs1.request_id;
2258: EXCEPTION