DBA Data[Home] [Help]

APPS.PA_RBS_MAPPING dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 2020: pa_rbs_prj_assignments ASSIGN,

2016: hd2.wp_flag = 'N' AND
2017: hd2.plan_version_id = ra.budget_version_id AND
2018: hd2.project_id = ra.project_id )
2019: ) det,
2020: pa_rbs_prj_assignments ASSIGN,
2021: pa_rbs_versions_b rbsv,
2022: pa_rbs_headers_b rbsh
2023: WHERE
2024: det.project_id = ASSIGN.project_id AND

Line 2045: , pa_rbs_prj_assignments asg

2041: SELECT DISTINCT
2042: ra.txn_accum_header_id
2043: , rbv2.rbs_version_id
2044: FROM pji_pa_proj_events_log LOG
2045: , pa_rbs_prj_assignments asg
2046: , pa_rbs_versions_b rbv1
2047: , pa_rbs_versions_b rbv2
2048: , pa_budget_versions bv
2049: , pa_resource_assignments ra

Line 2716: PA_RBS_PRJ_ASSIGNMENTS prj_assign

2712: struct_version_id)
2713: SELECT distinct tmp.txn_accum_header_id, prj_assign.rbs_version_id
2714: FROM PA_RBS_PLANS_IN_TMP tmp,
2715: PA_RESOURCE_ASSIGNMENTS res_assign,
2716: PA_RBS_PRJ_ASSIGNMENTS prj_assign
2717: WHERE tmp.source_id = res_assign.resource_assignment_id AND
2718: res_assign.project_id = prj_assign.project_id AND
2719: tmp.txn_accum_header_id not in
2720: (SELECT txn_accum_header_id