DBA Data[Home] [Help]

APPS.IGS_AD_IMP_001 dependencies on FND_PROFILE

Line 277: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN

273: AND EXISTS (SELECT 1 FROM igs_ad_test_segs_int WHERE status <> '1' AND interface_test_id = tst.interface_test_id);
274: COMMIT;
275:
276: --Dynamic Code block to be executed when IGR functionality is enabled.
277: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN
278: BEGIN
279: l_stmt := ' BEGIN
280: igr_imp_002.update_parent_record_status(:1);
281: END; ';