101:
102: SELECT payroll_action_id
103: INTO l_payroll_action_id
104: FROM pay_payroll_actions ppa,
105: fnd_conc_req_summary_v fcrs,
106: fnd_conc_req_summary_v fcrs1
107: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
108: AND fcrs.priority_request_id = fcrs1.priority_request_id
109: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
102: SELECT payroll_action_id
103: INTO l_payroll_action_id
104: FROM pay_payroll_actions ppa,
105: fnd_conc_req_summary_v fcrs,
106: fnd_conc_req_summary_v fcrs1
107: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
108: AND fcrs.priority_request_id = fcrs1.priority_request_id
109: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
110: AND ppa.request_id = fcrs1.request_id;