1011: BEGIN
1012: SELECT payroll_action_id
1013: INTO l_payroll_action_id
1014: FROM pay_payroll_actions ppa,
1015: fnd_conc_req_summary_v fcrs,
1016: fnd_conc_req_summary_v fcrs1
1017: WHERE fcrs.request_id = fnd_global.conc_request_id
1018: AND fcrs.priority_request_id = fcrs1.priority_request_id
1019: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
1012: SELECT payroll_action_id
1013: INTO l_payroll_action_id
1014: FROM pay_payroll_actions ppa,
1015: fnd_conc_req_summary_v fcrs,
1016: fnd_conc_req_summary_v fcrs1
1017: WHERE fcrs.request_id = fnd_global.conc_request_id
1018: AND fcrs.priority_request_id = fcrs1.priority_request_id
1019: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
1020: AND ppa.request_id = fcrs1.request_id;
1369: BEGIN
1370: SELECT payroll_action_id
1371: INTO l_payroll_action_id
1372: FROM pay_payroll_actions ppa,
1373: fnd_conc_req_summary_v fcrs,
1374: fnd_conc_req_summary_v fcrs1
1375: WHERE fcrs.request_id = fnd_global.conc_request_id
1376: AND fcrs.priority_request_id = fcrs1.priority_request_id
1377: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
1370: SELECT payroll_action_id
1371: INTO l_payroll_action_id
1372: FROM pay_payroll_actions ppa,
1373: fnd_conc_req_summary_v fcrs,
1374: fnd_conc_req_summary_v fcrs1
1375: WHERE fcrs.request_id = fnd_global.conc_request_id
1376: AND fcrs.priority_request_id = fcrs1.priority_request_id
1377: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
1378: AND ppa.request_id = fcrs1.request_id;