DBA Data[Home] [Help]

APPS.PAY_NO_PACCR_PKG dependencies on FND_CONC_REQ_SUMMARY_V

Line 1015: fnd_conc_req_summary_v fcrs,

1011: BEGIN
1012: SELECT payroll_action_id
1013: INTO l_payroll_action_id
1014: FROM pay_payroll_actions ppa,
1015: fnd_conc_req_summary_v fcrs,
1016: fnd_conc_req_summary_v fcrs1
1017: WHERE fcrs.request_id = fnd_global.conc_request_id
1018: AND fcrs.priority_request_id = fcrs1.priority_request_id
1019: AND ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 1016: fnd_conc_req_summary_v fcrs1

1012: SELECT payroll_action_id
1013: INTO l_payroll_action_id
1014: FROM pay_payroll_actions ppa,
1015: fnd_conc_req_summary_v fcrs,
1016: fnd_conc_req_summary_v fcrs1
1017: WHERE fcrs.request_id = fnd_global.conc_request_id
1018: AND fcrs.priority_request_id = fcrs1.priority_request_id
1019: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
1020: AND ppa.request_id = fcrs1.request_id;

Line 1373: fnd_conc_req_summary_v fcrs,

1369: BEGIN
1370: SELECT payroll_action_id
1371: INTO l_payroll_action_id
1372: FROM pay_payroll_actions ppa,
1373: fnd_conc_req_summary_v fcrs,
1374: fnd_conc_req_summary_v fcrs1
1375: WHERE fcrs.request_id = fnd_global.conc_request_id
1376: AND fcrs.priority_request_id = fcrs1.priority_request_id
1377: AND ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 1374: fnd_conc_req_summary_v fcrs1

1370: SELECT payroll_action_id
1371: INTO l_payroll_action_id
1372: FROM pay_payroll_actions ppa,
1373: fnd_conc_req_summary_v fcrs,
1374: fnd_conc_req_summary_v fcrs1
1375: WHERE fcrs.request_id = fnd_global.conc_request_id
1376: AND fcrs.priority_request_id = fcrs1.priority_request_id
1377: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
1378: AND ppa.request_id = fcrs1.request_id;