APPS.HZ_ORGANIZATION_PROFILES_PKG dependencies on HZ_ORGANIZATION_PROFILES_S

Line 374: fnd_api.g_miss_num, hz_organization_profiles_s.NEXTVAL,

370: home_country
371: )
372: VALUES (
373: DECODE(x_organization_profile_id,
374: fnd_api.g_miss_num, hz_organization_profiles_s.NEXTVAL,
375: NULL, hz_organization_profiles_s.NEXTVAL,
376: x_organization_profile_id),
377: DECODE(x_party_id, fnd_api.g_miss_num, NULL, x_party_id),
378: DECODE(x_organization_name,

Line 375: NULL, hz_organization_profiles_s.NEXTVAL,

371: )
372: VALUES (
373: DECODE(x_organization_profile_id,
374: fnd_api.g_miss_num, hz_organization_profiles_s.NEXTVAL,
375: NULL, hz_organization_profiles_s.NEXTVAL,
376: x_organization_profile_id),
377: DECODE(x_party_id, fnd_api.g_miss_num, NULL, x_party_id),
378: DECODE(x_organization_name,
379: fnd_api.g_miss_char, NULL,

Line 738: SELECT hz_organization_profiles_s.NEXTVAL

734: l_count NUMBER;
735: l_dummy VARCHAR2(1);
736: -- Bug 2117973: changed select...intos into cursors.
737: CURSOR c_seq IS
738: SELECT hz_organization_profiles_s.NEXTVAL
739: FROM dual;
740: CURSOR c_dupchk IS
741: SELECT 'Y'
742: FROM hz_organization_profiles hop