APPS.PJI_PJP_EXTRACTION_UTILS dependencies on FND_PROFILE

Line 592: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');

588: from
589: dual;
590:
591:
592: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
593:
594: if (upper(nvl(l_profile_check, 'N')) = 'Y') then
595:
596: update FND_PROFILE_OPTION_VALUES

Line 596: update FND_PROFILE_OPTION_VALUES

592: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
593:
594: if (upper(nvl(l_profile_check, 'N')) = 'Y') then
595:
596: update FND_PROFILE_OPTION_VALUES
597: set PROFILE_OPTION_VALUE = 'N'
598: where APPLICATION_ID = 1292 and
599: -- LEVEL_ID = 10001 and
600: PROFILE_OPTION_ID in

Line 602: from FND_PROFILE_OPTIONS

598: where APPLICATION_ID = 1292 and
599: -- LEVEL_ID = 10001 and
600: PROFILE_OPTION_ID in
601: (select PROFILE_OPTION_ID
602: from FND_PROFILE_OPTIONS
603: where APPLICATION_ID = 1292 and
604: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
605:
606: commit;