APPS.PA_RBS_MAPPING dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 2033: pa_rbs_prj_assignments ASSIGN,

2029: txn_accum_header_id
2030: FROM
2031: pa_rbs_map_t1 t1 where t1.worker_id = p_worker_id
2032: ) det,
2033: pa_rbs_prj_assignments ASSIGN,
2034: pa_rbs_versions_b rbsv,
2035: pa_rbs_headers_b rbsh
2036: WHERE
2037: det.project_id = ASSIGN.project_id AND

Line 2065: , pa_rbs_prj_assignments asg

2061: SELECT DISTINCT
2062: ra.txn_accum_header_id
2063: , rbv2.rbs_version_id
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

Line 2367: pa_rbs_prj_assignments ASSIGN,

2363: txn_accum_header_id
2364: FROM
2365: pa_rbs_map_t1 t1 where t1.worker_id = p_worker_id
2366: ) det,
2367: pa_rbs_prj_assignments ASSIGN,
2368: pa_rbs_versions_b rbsv,
2369: pa_rbs_headers_b rbsh
2370: WHERE
2371: p_calling_mode in ( 'FULL' , 'INCREMENTAL') AND

Line 2397: , pa_rbs_prj_assignments asg

2393: SELECT DISTINCT
2394: ra.txn_accum_header_id
2395: , rbv2.rbs_version_id
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

Line 3051: PA_RBS_PRJ_ASSIGNMENTS prj_assign

3047: struct_version_id)
3048: SELECT distinct tmp.txn_accum_header_id, prj_assign.rbs_version_id
3049: FROM PA_RBS_PLANS_IN_TMP tmp,
3050: PA_RESOURCE_ASSIGNMENTS res_assign,
3051: PA_RBS_PRJ_ASSIGNMENTS prj_assign
3052: WHERE tmp.source_id = res_assign.resource_assignment_id AND
3053: res_assign.project_id = prj_assign.project_id AND
3054: tmp.txn_accum_header_id not in
3055: (SELECT txn_accum_header_id