APPS.PA_RBS_MAPPING dependencies on PA_RBS_ELEMENTS_S

Line 999: || 'pa_rbs_elements_s.nextval,'

995: || ':p_struct_version_id,'
996: || 'RBS.rbs_element_id,'
997: || get_sql_clause(p_rule_id,p_level,'RES_TYP_ID') || ' ,'
998: || get_sql_clause(p_rule_id,p_level,'RES_SOURCE') || ' ,'
999: || 'pa_rbs_elements_s.nextval,'
1000: || get_sql_clause(p_rule_id,p_level,'TMP') ;
1001: l_tmp := 2 + p_counter ;
1002:
1003: l_FROM_clause := ' FROM ( SELECT DISTINCT struct_version_id, '

Line 1093: || ' pa_rbs_elements_s.nextval , '

1089: || ')' ;
1090:
1091: l_SELECT_clause := 'SELECT '
1092: || ':p_struct_version_id,'
1093: || ' pa_rbs_elements_s.nextval , '
1094: || ' -1 , '
1095: || ':p_struct_version_id';
1096:
1097: l_temp := 2+p_level ;

Line 1565: SELECT pa_rbs_elements_s.nextval INTO l_sequence FROM dual ;

1561:
1562:
1563: IF l_count = 0 THEN
1564:
1565: SELECT pa_rbs_elements_s.nextval INTO l_sequence FROM dual ;
1566: PA_RBS_UTILS.Populate_RBS_Element_Name(p_struct_version_id, -1, x_rbs_element_name_id, x_return_status);
1567:
1568: INSERT INTO pa_rbs_elements (
1569: rbs_version_id,