APPS.PA_RBS_MAPPING dependencies on PA_RBS_ELEM_IN_TEMP

Line 1256: delete pa_rbs_elem_in_temp;

1252: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1253: END IF;
1254:
1255: -- to get element_names start here
1256: delete pa_rbs_elem_in_temp;
1257:
1258: l_INSERT_clause := 'INSERT INTO pa_rbs_elem_in_temp ( '
1259: || 'resource_type_id,'
1260: || 'resource_source_id ) ' ;

Line 1258: l_INSERT_clause := 'INSERT INTO pa_rbs_elem_in_temp ( '

1254:
1255: -- to get element_names start here
1256: delete pa_rbs_elem_in_temp;
1257:
1258: l_INSERT_clause := 'INSERT INTO pa_rbs_elem_in_temp ( '
1259: || 'resource_type_id,'
1260: || 'resource_source_id ) ' ;
1261: l_SELECT_clause := 'SELECT distinct '
1262: || get_sql_clause(p_rule_id,p_level,'RES_TYP_ID') || ' ,'