APPS.PA_RBS_MAPPING dependencies on PA_RBS_ELEMENTS_S

Line 996: || 'pa_rbs_elements_s.nextval,'

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

Line 1090: || ' pa_rbs_elements_s.nextval , '

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

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

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