APPS.PAY_SE_EMPLOYMENT_STATISTICS dependencies on FND_CONC_REQ_SUMMARY_V

Line 2066: , fnd_conc_req_summary_v fcrs

2062: BEGIN
2063: SELECT payroll_action_id
2064: INTO l_payroll_action_id
2065: FROM pay_payroll_actions ppa
2066: , fnd_conc_req_summary_v fcrs
2067: , fnd_conc_req_summary_v fcrs1
2068: WHERE fcrs.request_id = fnd_global.conc_request_id
2069: AND fcrs.priority_request_id = fcrs1.priority_request_id
2070: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id

Line 2067: , fnd_conc_req_summary_v fcrs1

2063: SELECT payroll_action_id
2064: INTO l_payroll_action_id
2065: FROM pay_payroll_actions ppa
2066: , fnd_conc_req_summary_v fcrs
2067: , fnd_conc_req_summary_v fcrs1
2068: WHERE fcrs.request_id = fnd_global.conc_request_id
2069: AND fcrs.priority_request_id = fcrs1.priority_request_id
2070: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id
2071: AND ppa.request_id = fcrs1.request_id;

Line 2326: fnd_conc_req_summary_v fcrs,

2322: BEGIN
2323: SELECT payroll_action_id
2324: INTO l_payroll_action_id
2325: FROM pay_payroll_actions ppa,
2326: fnd_conc_req_summary_v fcrs,
2327: fnd_conc_req_summary_v fcrs1
2328: WHERE fcrs.request_id = fnd_global.conc_request_id
2329: AND fcrs.priority_request_id = fcrs1.priority_request_id
2330: AND ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 2327: fnd_conc_req_summary_v fcrs1

2323: SELECT payroll_action_id
2324: INTO l_payroll_action_id
2325: FROM pay_payroll_actions ppa,
2326: fnd_conc_req_summary_v fcrs,
2327: fnd_conc_req_summary_v fcrs1
2328: WHERE fcrs.request_id = fnd_global.conc_request_id
2329: AND fcrs.priority_request_id = fcrs1.priority_request_id
2330: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
2331: AND ppa.request_id = fcrs1.request_id;