APPS.PA_COMP_PROFILE_PVT dependencies on PA_COMPETENCE_PROFILES_S

Line 138: SELECT pa_competence_profiles_s.nextval

134: FETCH l_bg_csr INTO l_bg_id;
135: CLOSE l_bg_csr;
136:
137: IF g_profile_id = 0 THEN
138: SELECT pa_competence_profiles_s.nextval
139: INTO g_profile_id
140: FROM dual;
141: END IF;
142:

Line 253: SELECT pa_competence_profiles_s.nextval

249: RETURN;
250: END IF;
251:
252: IF g_profile_id = 0 THEN
253: SELECT pa_competence_profiles_s.nextval
254: INTO g_profile_id
255: FROM dual;
256: END IF;
257: