APPS.PAY_SE_HCIR dependencies on FND_CONC_REQ_SUMMARY_V

Line 38: FROM pay_payroll_actions ppa, fnd_conc_req_summary_v fcrs, fnd_conc_req_summary_v fcrs1

34: IF p_payroll_action_id IS NULL THEN
35: BEGIN
36: SELECT payroll_action_id
37: INTO l_payroll_action_id
38: FROM pay_payroll_actions ppa, fnd_conc_req_summary_v fcrs, fnd_conc_req_summary_v fcrs1
39: WHERE fcrs.request_id = fnd_global.conc_request_id
40: AND fcrs.priority_request_id = fcrs1.priority_request_id
41: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id
42: AND ppa.request_id = fcrs1.request_id;