799:
800: SELECT payroll_action_id
801: INTO l_payroll_action_id
802: FROM pay_payroll_actions ppa,
803: fnd_conc_req_summary_v fcrs,
804: fnd_conc_req_summary_v fcrs1
805: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
806: AND fcrs.priority_request_id = fcrs1.priority_request_id
807: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
800: SELECT payroll_action_id
801: INTO l_payroll_action_id
802: FROM pay_payroll_actions ppa,
803: fnd_conc_req_summary_v fcrs,
804: fnd_conc_req_summary_v fcrs1
805: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
806: AND fcrs.priority_request_id = fcrs1.priority_request_id
807: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
808: AND ppa.request_id = fcrs1.request_id;