DBA Data[Home] [Help]

APPS.PAY_NO_ARC_RSEA_07 dependencies on FND_CONC_REQ_SUMMARY_V

Line 1444: fnd_conc_req_summary_v fcrs,

1440: BEGIN
1441: SELECT payroll_action_id
1442: into l_payroll_action_id
1443: from pay_payroll_actions ppa,
1444: fnd_conc_req_summary_v fcrs,
1445: fnd_conc_req_summary_v fcrs1
1446: WHERE fcrs.request_id = fnd_global.conc_request_id
1447: and fcrs.priority_request_id = fcrs1.priority_request_id
1448: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 1445: fnd_conc_req_summary_v fcrs1

1441: SELECT payroll_action_id
1442: into l_payroll_action_id
1443: from pay_payroll_actions ppa,
1444: fnd_conc_req_summary_v fcrs,
1445: fnd_conc_req_summary_v fcrs1
1446: WHERE fcrs.request_id = fnd_global.conc_request_id
1447: and fcrs.priority_request_id = fcrs1.priority_request_id
1448: and ppa.request_id between fcrs1.request_id and fcrs.request_id
1449: and ppa.request_id = fcrs1.request_id;

Line 1957: fnd_conc_req_summary_v fcrs,

1953: BEGIN
1954: SELECT payroll_action_id
1955: into l_payroll_action_id
1956: from pay_payroll_actions ppa,
1957: fnd_conc_req_summary_v fcrs,
1958: fnd_conc_req_summary_v fcrs1
1959: WHERE fcrs.request_id = fnd_global.conc_request_id
1960: and fcrs.priority_request_id = fcrs1.priority_request_id
1961: and ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 1958: fnd_conc_req_summary_v fcrs1

1954: SELECT payroll_action_id
1955: into l_payroll_action_id
1956: from pay_payroll_actions ppa,
1957: fnd_conc_req_summary_v fcrs,
1958: fnd_conc_req_summary_v fcrs1
1959: WHERE fcrs.request_id = fnd_global.conc_request_id
1960: and fcrs.priority_request_id = fcrs1.priority_request_id
1961: and ppa.request_id between fcrs1.request_id and fcrs.request_id
1962: and ppa.request_id = fcrs1.request_id;