DBA Data[Home] [Help]

APPS.PA_RBS_MAPPING dependencies on PA_BUDGET_VERSIONS

Line 2068: , pa_budget_versions bv

2064: FROM pji_pa_proj_events_log LOG
2065: , pa_rbs_prj_assignments asg
2066: , pa_rbs_versions_b rbv1
2067: , pa_rbs_versions_b rbv2
2068: , pa_budget_versions bv
2069: , pa_resource_assignments ra
2070: WHERE
2071: LOG.event_type = 'RBS_PUSH' AND
2072: LOG.worker_id = p_worker_id AND

Line 2345: FROM pa_budget_versions bv ,

2341: AND ACCUM1.PROJECT_ID = p_project_id
2342: UNION ALL
2343: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) */
2344: DISTINCT RA.PROJECT_ID, RA.TXN_ACCUM_HEADER_ID
2345: FROM pa_budget_versions bv ,
2346: PA_RESOURCE_ASSIGNMENTS RA
2347: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2348: AND bv.PROJECT_ID = p_project_id
2349: AND bv.PROJECT_ID = RA.PROJECT_ID

Line 2400: , pa_budget_versions bv

2396: FROM pa_pjt_events LOG
2397: , pa_rbs_prj_assignments asg
2398: , pa_rbs_versions_b rbv1
2399: , pa_rbs_versions_b rbv2
2400: , pa_budget_versions bv
2401: , pa_resource_assignments ra
2402: WHERE
2403: LOG.event_type = 'RBS_PUSH' AND
2404: LOG.worker_id = p_worker_id AND