APPS.PA_RBS_MAPPING dependencies on PA_RBS_ELEM_IN_TEMP

Line 1253: delete pa_rbs_elem_in_temp;

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

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

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