APPS.PAY_SE_FORA dependencies on FND_CONC_REQ_SUMMARY_V

Line 1967: , fnd_conc_req_summary_v fcrs

1963: BEGIN
1964: SELECT payroll_action_id
1965: INTO l_payroll_action_id
1966: FROM pay_payroll_actions ppa
1967: , fnd_conc_req_summary_v fcrs
1968: , fnd_conc_req_summary_v fcrs1
1969: WHERE fcrs.request_id = fnd_global.conc_request_id
1970: AND fcrs.priority_request_id = fcrs1.priority_request_id
1971: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id

Line 1968: , fnd_conc_req_summary_v fcrs1

1964: SELECT payroll_action_id
1965: INTO l_payroll_action_id
1966: FROM pay_payroll_actions ppa
1967: , fnd_conc_req_summary_v fcrs
1968: , fnd_conc_req_summary_v fcrs1
1969: WHERE fcrs.request_id = fnd_global.conc_request_id
1970: AND fcrs.priority_request_id = fcrs1.priority_request_id
1971: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id
1972: AND ppa.request_id = fcrs1.request_id;

Line 2252: fnd_conc_req_summary_v fcrs,

2248: BEGIN
2249: SELECT payroll_action_id
2250: INTO l_payroll_action_id
2251: FROM pay_payroll_actions ppa,
2252: fnd_conc_req_summary_v fcrs,
2253: fnd_conc_req_summary_v fcrs1
2254: WHERE fcrs.request_id = fnd_global.conc_request_id
2255: AND fcrs.priority_request_id = fcrs1.priority_request_id
2256: AND ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 2253: fnd_conc_req_summary_v fcrs1

2249: SELECT payroll_action_id
2250: INTO l_payroll_action_id
2251: FROM pay_payroll_actions ppa,
2252: fnd_conc_req_summary_v fcrs,
2253: fnd_conc_req_summary_v fcrs1
2254: WHERE fcrs.request_id = fnd_global.conc_request_id
2255: AND fcrs.priority_request_id = fcrs1.priority_request_id
2256: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
2257: AND ppa.request_id = fcrs1.request_id;