APPS.PA_RBS_MAPPING dependencies on PA_RBS_TXN_ACCUM_MAP

Line 907: ' FROM pa_rbs_txn_accum_map ' ||

903: ' RBS.rbs_level(+) = :p_level AND ' ||
904: ' TMP.resource_class_id = :p_res_class_id AND ' ||
905: ' TMP.txn_accum_header_id NOT IN ' ||
906: ' (SELECT txn_accum_header_id ' ||
907: ' FROM pa_rbs_txn_accum_map ' ||
908: ' WHERE struct_version_id = :p_struct_version_id)' ;
909:
910: ELSE
911:

Line 921: ' FROM pa_rbs_txn_accum_map ' ||

917: ' RBS.rbs_level(+) = :p_level AND ' ||
918: ' TMP.resource_class_id = :p_res_class_id AND ' ||
919: ' TMP.txn_accum_header_id NOT IN ' ||
920: ' (SELECT txn_accum_header_id ' ||
921: ' FROM pa_rbs_txn_accum_map ' ||
922: ' WHERE struct_version_id = :p_struct_version_id)' ;
923:
924: END IF;
925:

Line 1366: --create mapping inserting into pa_rbs_txn_accum_map

1362:
1363: END ;
1364:
1365: ------------------------------------------------------
1366: --create mapping inserting into pa_rbs_txn_accum_map
1367: ------------------------------------------------------
1368:
1369: PROCEDURE populate_txn_map
1370: (

Line 1395: l_INSERT_clause := 'INSERT INTO pa_rbs_txn_accum_map ('

1391: pa_debug.g_err_stage:= 'Inside populate_txn_map- p_struct_version_id :'|| p_struct_version_id || ' p_max_level: ' || p_max_level || ' p_rule_id:'||p_rule_id;
1392: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1393: END IF;
1394:
1395: l_INSERT_clause := 'INSERT INTO pa_rbs_txn_accum_map ('
1396: || 'txn_accum_header_id,'
1397: || 'element_id,'
1398: || 'struct_version_id,'
1399: || 'last_update_date,'

Line 1549: pa_rbs_txn_accum_map

1545: bulk collect into l_txn_header_id
1546: from pa_rbs_map_tmp2
1547: where resource_class_id = p_res_class_id
1548: and txn_accum_header_id not in (SELECT txn_accum_header_id FROM
1549: pa_rbs_txn_accum_map
1550: WHERE struct_version_id = p_struct_version_id ) ;
1551:
1552:
1553: IF SQL%ROWCOUNT>0 THEN

Line 1614: INSERT INTO pa_rbs_txn_accum_map (

1610:
1611: END IF;
1612:
1613: FORALL i IN 1..l_txn_header_id.count
1614: INSERT INTO pa_rbs_txn_accum_map (
1615: txn_accum_header_id,
1616: element_id,
1617: struct_version_id,
1618: last_update_date,

Line 2026: (SELECT txn_accum_header_id FROM pa_rbs_txn_accum_map

2022: pa_rbs_headers_b rbsh
2023: WHERE
2024: det.project_id = ASSIGN.project_id AND
2025: det.txn_accum_header_id NOT IN
2026: (SELECT txn_accum_header_id FROM pa_rbs_txn_accum_map
2027: WHERE struct_version_id = ASSIGN.rbs_version_id ) AND
2028: ASSIGN.reporting_usage_flag = 'Y' AND
2029: ASSIGN.rbs_version_id = rbsv.rbs_version_id AND
2030: rbsv.current_reporting_flag = 'Y' AND

Line 2065: FROM pa_rbs_txn_accum_map

2061: ra.txn_accum_header_id IS NOT NULL AND
2062: ra.txn_accum_header_id NOT IN
2063: (
2064: SELECT txn_accum_header_id
2065: FROM pa_rbs_txn_accum_map
2066: WHERE struct_version_id = rbv2.rbs_version_id
2067: );
2068:
2069: Pji_Pjp_Fp_Curr_Wrap.print_time( ' # rows inserted = ' || SQL%ROWCOUNT );

Line 2611: FROM pa_rbs_txn_accum_map b

2607: person_type_id --bug#4098679
2608: FROM PA_RBS_PLANS_OUT_TMP a
2609: WHERE NOT EXISTS
2610: (SELECT 1
2611: FROM pa_rbs_txn_accum_map b
2612: WHERE b.struct_version_id = p_rbs_version_id and
2613: b.txn_accum_header_id=a.txn_accum_header_id);
2614:
2615:

Line 2696: from pa_rbs_txn_accum_map map

2692:
2693: UPDATE PA_RBS_PLANS_OUT_TMP tmp
2694: SET tmp.rbs_element_id =
2695: (select map.element_id
2696: from pa_rbs_txn_accum_map map
2697: where map.txn_accum_header_id = tmp.txn_accum_header_id
2698: and map.struct_version_id = p_rbs_version_id);
2699:
2700:

Line 2721: FROM pa_rbs_txn_accum_map

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
2721: FROM pa_rbs_txn_accum_map
2722: WHERE struct_version_id = prj_assign.rbs_version_id );
2723:
2724: SELECT distinct struct_version_id
2725: BULK COLLECT