APPS.PAY_NO_EOY_ARCHIVE dependencies on FND_CONC_REQ_SUMMARY_V

Line 3171: fnd_conc_req_summary_v fcrs,

3167: BEGIN
3168: SELECT payroll_action_id
3169: into l_payroll_action_id
3170: from pay_payroll_actions ppa,
3171: fnd_conc_req_summary_v fcrs,
3172: fnd_conc_req_summary_v fcrs1
3173: WHERE fcrs.request_id = fnd_global.conc_request_id
3174: and fcrs.priority_request_id = fcrs1.priority_request_id
3175: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 3172: fnd_conc_req_summary_v fcrs1

3168: SELECT payroll_action_id
3169: into l_payroll_action_id
3170: from pay_payroll_actions ppa,
3171: fnd_conc_req_summary_v fcrs,
3172: fnd_conc_req_summary_v fcrs1
3173: WHERE fcrs.request_id = fnd_global.conc_request_id
3174: and fcrs.priority_request_id = fcrs1.priority_request_id
3175: and ppa.request_id between fcrs1.request_id and fcrs.request_id
3176: and ppa.request_id = fcrs1.request_id;

Line 3780: fnd_conc_req_summary_v fcrs,

3776: BEGIN
3777: SELECT payroll_action_id
3778: into l_payroll_action_id
3779: from pay_payroll_actions ppa,
3780: fnd_conc_req_summary_v fcrs,
3781: fnd_conc_req_summary_v fcrs1
3782: WHERE fcrs.request_id = fnd_global.conc_request_id
3783: and fcrs.priority_request_id = fcrs1.priority_request_id
3784: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 3781: fnd_conc_req_summary_v fcrs1

3777: SELECT payroll_action_id
3778: into l_payroll_action_id
3779: from pay_payroll_actions ppa,
3780: fnd_conc_req_summary_v fcrs,
3781: fnd_conc_req_summary_v fcrs1
3782: WHERE fcrs.request_id = fnd_global.conc_request_id
3783: and fcrs.priority_request_id = fcrs1.priority_request_id
3784: and ppa.request_id between fcrs1.request_id and fcrs.request_id
3785: and ppa.request_id = fcrs1.request_id;

Line 4610: fnd_conc_req_summary_v fcrs,

4606: BEGIN
4607: SELECT payroll_action_id
4608: into l_payroll_action_id
4609: from pay_payroll_actions ppa,
4610: fnd_conc_req_summary_v fcrs,
4611: fnd_conc_req_summary_v fcrs1
4612: WHERE fcrs.request_id = fnd_global.conc_request_id
4613: and fcrs.priority_request_id = fcrs1.priority_request_id
4614: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 4611: fnd_conc_req_summary_v fcrs1

4607: SELECT payroll_action_id
4608: into l_payroll_action_id
4609: from pay_payroll_actions ppa,
4610: fnd_conc_req_summary_v fcrs,
4611: fnd_conc_req_summary_v fcrs1
4612: WHERE fcrs.request_id = fnd_global.conc_request_id
4613: and fcrs.priority_request_id = fcrs1.priority_request_id
4614: and ppa.request_id between fcrs1.request_id and fcrs.request_id
4615: and ppa.request_id = fcrs1.request_id;

Line 5238: fnd_conc_req_summary_v fcrs,

5234: BEGIN
5235: SELECT payroll_action_id
5236: into l_payroll_action_id
5237: from pay_payroll_actions ppa,
5238: fnd_conc_req_summary_v fcrs,
5239: fnd_conc_req_summary_v fcrs1
5240: WHERE fcrs.request_id = fnd_global.conc_request_id
5241: and fcrs.priority_request_id = fcrs1.priority_request_id
5242: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 5239: fnd_conc_req_summary_v fcrs1

5235: SELECT payroll_action_id
5236: into l_payroll_action_id
5237: from pay_payroll_actions ppa,
5238: fnd_conc_req_summary_v fcrs,
5239: fnd_conc_req_summary_v fcrs1
5240: WHERE fcrs.request_id = fnd_global.conc_request_id
5241: and fcrs.priority_request_id = fcrs1.priority_request_id
5242: and ppa.request_id between fcrs1.request_id and fcrs.request_id
5243: and ppa.request_id = fcrs1.request_id;

Line 5895: fnd_conc_req_summary_v fcrs,

5891: BEGIN
5892: SELECT payroll_action_id
5893: into l_payroll_action_id
5894: from pay_payroll_actions ppa,
5895: fnd_conc_req_summary_v fcrs,
5896: fnd_conc_req_summary_v fcrs1
5897: WHERE fcrs.request_id = fnd_global.conc_request_id
5898: and fcrs.priority_request_id = fcrs1.priority_request_id
5899: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 5896: fnd_conc_req_summary_v fcrs1

5892: SELECT payroll_action_id
5893: into l_payroll_action_id
5894: from pay_payroll_actions ppa,
5895: fnd_conc_req_summary_v fcrs,
5896: fnd_conc_req_summary_v fcrs1
5897: WHERE fcrs.request_id = fnd_global.conc_request_id
5898: and fcrs.priority_request_id = fcrs1.priority_request_id
5899: and ppa.request_id between fcrs1.request_id and fcrs.request_id
5900: and ppa.request_id = fcrs1.request_id;