APPS.PAY_NO_ARC_RSEA_07 dependencies on FND_CONC_REQ_SUMMARY_V

Line 1598: fnd_conc_req_summary_v fcrs,

1594: BEGIN
1595: SELECT payroll_action_id
1596: into l_payroll_action_id
1597: from pay_payroll_actions ppa,
1598: fnd_conc_req_summary_v fcrs,
1599: fnd_conc_req_summary_v fcrs1
1600: WHERE fcrs.request_id = fnd_global.conc_request_id
1601: and fcrs.priority_request_id = fcrs1.priority_request_id
1602: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 1599: fnd_conc_req_summary_v fcrs1

1595: SELECT payroll_action_id
1596: into l_payroll_action_id
1597: from pay_payroll_actions ppa,
1598: fnd_conc_req_summary_v fcrs,
1599: fnd_conc_req_summary_v fcrs1
1600: WHERE fcrs.request_id = fnd_global.conc_request_id
1601: and fcrs.priority_request_id = fcrs1.priority_request_id
1602: and ppa.request_id between fcrs1.request_id and fcrs.request_id
1603: and ppa.request_id = fcrs1.request_id;

Line 2258: fnd_conc_req_summary_v fcrs,

2254: BEGIN
2255: SELECT payroll_action_id
2256: into l_payroll_action_id
2257: from pay_payroll_actions ppa,
2258: fnd_conc_req_summary_v fcrs,
2259: fnd_conc_req_summary_v fcrs1
2260: WHERE fcrs.request_id = fnd_global.conc_request_id
2261: and fcrs.priority_request_id = fcrs1.priority_request_id
2262: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 2259: fnd_conc_req_summary_v fcrs1

2255: SELECT payroll_action_id
2256: into l_payroll_action_id
2257: from pay_payroll_actions ppa,
2258: fnd_conc_req_summary_v fcrs,
2259: fnd_conc_req_summary_v fcrs1
2260: WHERE fcrs.request_id = fnd_global.conc_request_id
2261: and fcrs.priority_request_id = fcrs1.priority_request_id
2262: and ppa.request_id between fcrs1.request_id and fcrs.request_id
2263: and ppa.request_id = fcrs1.request_id;