APPS.PA_RBS_MAPPING dependencies on PA_RBS_PLANS_IN_TMP

Line 2296: FROM PA_RBS_PLANS_IN_TMP

2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2293:
2294: SELECT distinct revenue_category_code
2295: BULK COLLECT INTO l_revenue_category
2296: FROM PA_RBS_PLANS_IN_TMP
2297: WHERE revenue_category_code NOT IN
2298: (select resource_name from pa_rbs_element_map where resource_type_id = 14)
2299: AND revenue_category_code IS NOT NULL; /*Added for bug 3575147*/
2300:

Line 2308: FROM PA_RBS_PLANS_IN_TMP

2304:
2305:
2306: SELECT distinct person_type_code
2307: BULK COLLECT INTO l_person_type_code
2308: FROM PA_RBS_PLANS_IN_TMP
2309: WHERE person_type_code NOT IN
2310: (select resource_name from pa_rbs_element_map where resource_type_id = 11)
2311: AND person_type_code IS NOT NULL; /* Added for bug 3575147 */
2312:

Line 2417: FROM PA_RBS_PLANS_IN_TMP

2413: person_id,
2414: bom_equipment_id,
2415: bom_labor_id,
2416: person_type_code
2417: FROM PA_RBS_PLANS_IN_TMP
2418: WHERE rowid NOT IN
2419: (SELECT /*+ ordered */ tmp.rowid
2420: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2421: WHERE

Line 2420: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2416: person_type_code
2417: FROM PA_RBS_PLANS_IN_TMP
2418: WHERE rowid NOT IN
2419: (SELECT /*+ ordered */ tmp.rowid
2420: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2421: WHERE
2422: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2423: head.project_role_id = nvl(tmp.role_id,-1) AND
2424: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND

Line 2502: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2498: tmp.person_id,
2499: tmp.bom_equipment_id,
2500: tmp.bom_labor_id,
2501: tmp.person_type_code
2502: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2503: WHERE
2504: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2505: head.project_role_id = nvl(tmp.role_id,-1) AND
2506: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND

Line 2714: FROM PA_RBS_PLANS_IN_TMP tmp,

2710: INSERT INTO pa_rbs_map_tmp1
2711: (txn_accum_header_id,
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

Line 2773: FROM pa_rbs_map_tmp1 tmp1, PA_RBS_PLANS_IN_TMP tmp

2769: tmp.event_type_id, --- event type
2770: tmp.person_id, --- named person
2771: tmp.bom_equipment_id, --- BOM equipment
2772: tmp.bom_labor_id --- BOM labor
2773: FROM pa_rbs_map_tmp1 tmp1, PA_RBS_PLANS_IN_TMP tmp
2774: WHERE tmp1.struct_version_id = l_rbs_struct_version_id(i) AND
2775: tmp1.txn_accum_header_id = tmp.txn_accum_header_id AND
2776: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);
2777:

Line 2776: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);

2772: tmp.bom_labor_id --- BOM labor
2773: FROM pa_rbs_map_tmp1 tmp1, PA_RBS_PLANS_IN_TMP tmp
2774: WHERE tmp1.struct_version_id = l_rbs_struct_version_id(i) AND
2775: tmp1.txn_accum_header_id = tmp.txn_accum_header_id AND
2776: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);
2777:
2778: IF g_debug_mode = 'Y' THEN
2779: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||l_rbs_struct_version_id(i) ;
2780: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;