DBA Data[Home] [Help]

APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on FND_CONC_REQ_SUMMARY_V

Line 3068: ,fnd_conc_req_summary_v fcrs

3064: BEGIN
3065: SELECT payroll_action_id
3066: INTO l_payroll_action_id
3067: FROM pay_payroll_actions ppa
3068: ,fnd_conc_req_summary_v fcrs
3069: ,fnd_conc_req_summary_v fcrs1
3070: WHERE fcrs.request_id = fnd_global.conc_request_id
3071: AND fcrs.priority_request_id = fcrs1.priority_request_id
3072: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id

Line 3069: ,fnd_conc_req_summary_v fcrs1

3065: SELECT payroll_action_id
3066: INTO l_payroll_action_id
3067: FROM pay_payroll_actions ppa
3068: ,fnd_conc_req_summary_v fcrs
3069: ,fnd_conc_req_summary_v fcrs1
3070: WHERE fcrs.request_id = fnd_global.conc_request_id
3071: AND fcrs.priority_request_id = fcrs1.priority_request_id
3072: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id
3073: AND ppa.request_id = fcrs1.request_id;