3249: begin
3250: select payroll_action_id
3251: into l_payroll_action_id
3252: from pay_payroll_actions ppa,
3253: fnd_conc_req_summary_v fcrs,
3254: fnd_conc_req_summary_v fcrs1
3255: where fcrs.request_id = fnd_global.conc_request_id
3256: and fcrs.priority_request_id = fcrs1.priority_request_id
3257: and ppa.request_id between fcrs1.request_id and fcrs.request_id
3250: select payroll_action_id
3251: into l_payroll_action_id
3252: from pay_payroll_actions ppa,
3253: fnd_conc_req_summary_v fcrs,
3254: fnd_conc_req_summary_v fcrs1
3255: where fcrs.request_id = fnd_global.conc_request_id
3256: and fcrs.priority_request_id = fcrs1.priority_request_id
3257: and ppa.request_id between fcrs1.request_id and fcrs.request_id
3258: and ppa.request_id = fcrs1.request_id;