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: