DBA Data[Home] [Help]

APPS.PAY_NO_SUPPORT_ORDER dependencies on FND_CONC_REQ_SUMMARY_V

Line 1111: fnd_conc_req_summary_v fcrs,

1107: --fnd_file.put_line(fnd_file.log,'SUGARG: p_payroll_action_id IS NULL ');
1108: SELECT payroll_action_id
1109: INTO l_payroll_action_id
1110: FROM pay_payroll_actions ppa,
1111: fnd_conc_req_summary_v fcrs,
1112: fnd_conc_req_summary_v fcrs1
1113: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
1114: AND fcrs.priority_request_id = fcrs1.priority_request_id
1115: AND ppa.request_id between fcrs1.request_id and fcrs.request_id

Line 1112: fnd_conc_req_summary_v fcrs1

1108: SELECT payroll_action_id
1109: INTO l_payroll_action_id
1110: FROM pay_payroll_actions ppa,
1111: fnd_conc_req_summary_v fcrs,
1112: fnd_conc_req_summary_v fcrs1
1113: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
1114: AND fcrs.priority_request_id = fcrs1.priority_request_id
1115: AND ppa.request_id between fcrs1.request_id and fcrs.request_id
1116: AND ppa.request_id = fcrs1.request_id;