APPS.PAY_SE_FORA dependencies on FND_CONC_REQ_SUMMARY_V

Line 1993: , fnd_conc_req_summary_v fcrs

1989: BEGIN
1990: SELECT payroll_action_id
1991: INTO l_payroll_action_id
1992: FROM pay_payroll_actions ppa
1993: , fnd_conc_req_summary_v fcrs
1994: , fnd_conc_req_summary_v fcrs1
1995: WHERE fcrs.request_id = fnd_global.conc_request_id
1996: AND fcrs.priority_request_id = fcrs1.priority_request_id
1997: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id

Line 1994: , fnd_conc_req_summary_v fcrs1

1990: SELECT payroll_action_id
1991: INTO l_payroll_action_id
1992: FROM pay_payroll_actions ppa
1993: , fnd_conc_req_summary_v fcrs
1994: , fnd_conc_req_summary_v fcrs1
1995: WHERE fcrs.request_id = fnd_global.conc_request_id
1996: AND fcrs.priority_request_id = fcrs1.priority_request_id
1997: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id
1998: AND ppa.request_id = fcrs1.request_id;

Line 2281: fnd_conc_req_summary_v fcrs,

2277: BEGIN
2278: SELECT payroll_action_id
2279: INTO l_payroll_action_id
2280: FROM pay_payroll_actions ppa,
2281: fnd_conc_req_summary_v fcrs,
2282: fnd_conc_req_summary_v fcrs1
2283: WHERE fcrs.request_id = fnd_global.conc_request_id
2284: AND fcrs.priority_request_id = fcrs1.priority_request_id
2285: AND ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 2282: fnd_conc_req_summary_v fcrs1

2278: SELECT payroll_action_id
2279: INTO l_payroll_action_id
2280: FROM pay_payroll_actions ppa,
2281: fnd_conc_req_summary_v fcrs,
2282: fnd_conc_req_summary_v fcrs1
2283: WHERE fcrs.request_id = fnd_global.conc_request_id
2284: AND fcrs.priority_request_id = fcrs1.priority_request_id
2285: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
2286: AND ppa.request_id = fcrs1.request_id;