APPS.PA_RBS_MAPPING dependencies on PA_RBS_PLANS_IN_TMP

Line 2631: FROM PA_RBS_PLANS_IN_TMP

2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2628:
2629: SELECT distinct revenue_category_code
2630: BULK COLLECT INTO l_revenue_category
2631: FROM PA_RBS_PLANS_IN_TMP
2632: WHERE revenue_category_code NOT IN
2633: (select resource_name from pa_rbs_element_map where resource_type_id = 14)
2634: AND revenue_category_code IS NOT NULL; /*Added for bug 3575147*/
2635:

Line 2643: FROM PA_RBS_PLANS_IN_TMP

2639:
2640:
2641: SELECT distinct person_type_code
2642: BULK COLLECT INTO l_person_type_code
2643: FROM PA_RBS_PLANS_IN_TMP
2644: WHERE person_type_code NOT IN
2645: (select resource_name from pa_rbs_element_map where resource_type_id = 11)
2646: AND person_type_code IS NOT NULL; /* Added for bug 3575147 */
2647:

Line 2752: FROM PA_RBS_PLANS_IN_TMP

2748: person_id,
2749: bom_equipment_id,
2750: bom_labor_id,
2751: person_type_code
2752: FROM PA_RBS_PLANS_IN_TMP
2753: WHERE rowid NOT IN
2754: (SELECT /*+ ordered */ tmp.rowid
2755: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2756: WHERE

Line 2755: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2751: person_type_code
2752: FROM PA_RBS_PLANS_IN_TMP
2753: WHERE rowid NOT IN
2754: (SELECT /*+ ordered */ tmp.rowid
2755: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2756: WHERE
2757: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2758: head.project_role_id = nvl(tmp.role_id,-1) AND
2759: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND

Line 2837: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2833: tmp.person_id,
2834: tmp.bom_equipment_id,
2835: tmp.bom_labor_id,
2836: tmp.person_type_code
2837: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2838: WHERE
2839: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2840: head.project_role_id = nvl(tmp.role_id,-1) AND
2841: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND

Line 3049: FROM PA_RBS_PLANS_IN_TMP tmp,

3045: INSERT INTO pa_rbs_map_tmp1
3046: (txn_accum_header_id,
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

Line 3108: FROM pa_rbs_map_tmp1 tmp1, PA_RBS_PLANS_IN_TMP tmp

3104: tmp.event_type_id, --- event type
3105: tmp.person_id, --- named person
3106: tmp.bom_equipment_id, --- BOM equipment
3107: tmp.bom_labor_id --- BOM labor
3108: FROM pa_rbs_map_tmp1 tmp1, PA_RBS_PLANS_IN_TMP tmp
3109: WHERE tmp1.struct_version_id = l_rbs_struct_version_id(i) AND
3110: tmp1.txn_accum_header_id = tmp.txn_accum_header_id AND
3111: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);
3112:

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

3107: tmp.bom_labor_id --- BOM labor
3108: FROM pa_rbs_map_tmp1 tmp1, PA_RBS_PLANS_IN_TMP tmp
3109: WHERE tmp1.struct_version_id = l_rbs_struct_version_id(i) AND
3110: tmp1.txn_accum_header_id = tmp.txn_accum_header_id AND
3111: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);
3112:
3113: IF g_debug_mode = 'Y' THEN
3114: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||l_rbs_struct_version_id(i) ;
3115: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;