APPS.PA_RBS_MAPPING dependencies on PA_RBS_MAP_TMP3

Line 332: DELETE pa_rbs_map_tmp3;

328: DELETE pa_rbs_map_tmp1;
329: WHEN 2 THEN
330: DELETE pa_rbs_map_tmp2;
331: WHEN 3 THEN
332: DELETE pa_rbs_map_tmp3;
333: WHEN 4 THEN
334: DELETE pa_rbs_map_tmp4;
335: WHEN 5 THEN
336: DELETE pa_rbs_map_tmp5;

Line 873: --delete pa_rbs_map_tmp3;

869:
870:
871: x_return_status := 0;
872:
873: --delete pa_rbs_map_tmp3;
874: l_INSERT_clause := 'INSERT INTO pa_rbs_map_tmp3('
875: || 'txn_accum_header_id,'
876: || 'struct_version_id,'
877: || 'element_version_id,'

Line 874: l_INSERT_clause := 'INSERT INTO pa_rbs_map_tmp3('

870:
871: x_return_status := 0;
872:
873: --delete pa_rbs_map_tmp3;
874: l_INSERT_clause := 'INSERT INTO pa_rbs_map_tmp3('
875: || 'txn_accum_header_id,'
876: || 'struct_version_id,'
877: || 'element_version_id,'
878: || 'parent_element_version_id,'

Line 1418: || 'pa_rbs_map_tmp3 TMP, '

1414: || '''' || sysdate || '''' || ' ,'
1415: || ':g_user_id,'
1416: || ':g_login_id ';
1417: l_FROM_clause := ' FROM '
1418: || 'pa_rbs_map_tmp3 TMP, '
1419: || 'pa_rbs_elements RBS' ;
1420: l_WHERE_clause := ' WHERE '
1421: || get_sql_clause(p_rule_id,p_max_level,'EQUAL') || ' AND '
1422: || 'TMP.element_version_id IS NULL '

Line 1441: l_FROM_clause := ' FROM pa_rbs_map_tmp3 TMP ' ;

1437: || '''' || sysdate || '''' || ' ,'
1438: || ':g_user_id,'
1439: || ':g_login_id';
1440:
1441: l_FROM_clause := ' FROM pa_rbs_map_tmp3 TMP ' ;
1442: l_WHERE_clause := 'WHERE TMP.element_version_id IS NOT NULL ' ;
1443:
1444: l_SQL_statement2 := l_SELECT_clause || ' ' ||
1445: l_FROM_clause || ' ' ||