APPS.PAY_NO_EOY_ARCHIVE dependencies on FND_CONC_REQ_SUMMARY_V

Line 3787: fnd_conc_req_summary_v fcrs,

3783: BEGIN
3784: SELECT payroll_action_id
3785: into l_payroll_action_id
3786: from pay_payroll_actions ppa,
3787: fnd_conc_req_summary_v fcrs,
3788: fnd_conc_req_summary_v fcrs1
3789: WHERE fcrs.request_id = fnd_global.conc_request_id
3790: and fcrs.priority_request_id = fcrs1.priority_request_id
3791: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 3788: fnd_conc_req_summary_v fcrs1

3784: SELECT payroll_action_id
3785: into l_payroll_action_id
3786: from pay_payroll_actions ppa,
3787: fnd_conc_req_summary_v fcrs,
3788: fnd_conc_req_summary_v fcrs1
3789: WHERE fcrs.request_id = fnd_global.conc_request_id
3790: and fcrs.priority_request_id = fcrs1.priority_request_id
3791: and ppa.request_id between fcrs1.request_id and fcrs.request_id
3792: and ppa.request_id = fcrs1.request_id;

Line 4528: fnd_conc_req_summary_v fcrs,

4524: BEGIN
4525: SELECT payroll_action_id
4526: into l_payroll_action_id
4527: from pay_payroll_actions ppa,
4528: fnd_conc_req_summary_v fcrs,
4529: fnd_conc_req_summary_v fcrs1
4530: WHERE fcrs.request_id = fnd_global.conc_request_id
4531: and fcrs.priority_request_id = fcrs1.priority_request_id
4532: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 4529: fnd_conc_req_summary_v fcrs1

4525: SELECT payroll_action_id
4526: into l_payroll_action_id
4527: from pay_payroll_actions ppa,
4528: fnd_conc_req_summary_v fcrs,
4529: fnd_conc_req_summary_v fcrs1
4530: WHERE fcrs.request_id = fnd_global.conc_request_id
4531: and fcrs.priority_request_id = fcrs1.priority_request_id
4532: and ppa.request_id between fcrs1.request_id and fcrs.request_id
4533: and ppa.request_id = fcrs1.request_id;

Line 5530: fnd_conc_req_summary_v fcrs,

5526: BEGIN
5527: SELECT payroll_action_id
5528: into l_payroll_action_id
5529: from pay_payroll_actions ppa,
5530: fnd_conc_req_summary_v fcrs,
5531: fnd_conc_req_summary_v fcrs1
5532: WHERE fcrs.request_id = fnd_global.conc_request_id
5533: and fcrs.priority_request_id = fcrs1.priority_request_id
5534: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 5531: fnd_conc_req_summary_v fcrs1

5527: SELECT payroll_action_id
5528: into l_payroll_action_id
5529: from pay_payroll_actions ppa,
5530: fnd_conc_req_summary_v fcrs,
5531: fnd_conc_req_summary_v fcrs1
5532: WHERE fcrs.request_id = fnd_global.conc_request_id
5533: and fcrs.priority_request_id = fcrs1.priority_request_id
5534: and ppa.request_id between fcrs1.request_id and fcrs.request_id
5535: and ppa.request_id = fcrs1.request_id;

Line 6223: fnd_conc_req_summary_v fcrs,

6219: BEGIN
6220: SELECT payroll_action_id
6221: into l_payroll_action_id
6222: from pay_payroll_actions ppa,
6223: fnd_conc_req_summary_v fcrs,
6224: fnd_conc_req_summary_v fcrs1
6225: WHERE fcrs.request_id = fnd_global.conc_request_id
6226: and fcrs.priority_request_id = fcrs1.priority_request_id
6227: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 6224: fnd_conc_req_summary_v fcrs1

6220: SELECT payroll_action_id
6221: into l_payroll_action_id
6222: from pay_payroll_actions ppa,
6223: fnd_conc_req_summary_v fcrs,
6224: fnd_conc_req_summary_v fcrs1
6225: WHERE fcrs.request_id = fnd_global.conc_request_id
6226: and fcrs.priority_request_id = fcrs1.priority_request_id
6227: and ppa.request_id between fcrs1.request_id and fcrs.request_id
6228: and ppa.request_id = fcrs1.request_id;

Line 7012: fnd_conc_req_summary_v fcrs,

7008: BEGIN
7009: SELECT payroll_action_id
7010: into l_payroll_action_id
7011: from pay_payroll_actions ppa,
7012: fnd_conc_req_summary_v fcrs,
7013: fnd_conc_req_summary_v fcrs1
7014: WHERE fcrs.request_id = fnd_global.conc_request_id
7015: and fcrs.priority_request_id = fcrs1.priority_request_id
7016: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 7013: fnd_conc_req_summary_v fcrs1

7009: SELECT payroll_action_id
7010: into l_payroll_action_id
7011: from pay_payroll_actions ppa,
7012: fnd_conc_req_summary_v fcrs,
7013: fnd_conc_req_summary_v fcrs1
7014: WHERE fcrs.request_id = fnd_global.conc_request_id
7015: and fcrs.priority_request_id = fcrs1.priority_request_id
7016: and ppa.request_id between fcrs1.request_id and fcrs.request_id
7017: and ppa.request_id = fcrs1.request_id;