APPS.PJI_PJP_EXTRACTION_UTILS dependencies on FND_PROFILE

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

546: from
547: dual;
548:
549:
550: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
551:
552: if (upper(nvl(l_profile_check, 'N')) = 'Y') then
553:
554: update FND_PROFILE_OPTION_VALUES

Line 554: update FND_PROFILE_OPTION_VALUES

550: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
551:
552: if (upper(nvl(l_profile_check, 'N')) = 'Y') then
553:
554: update FND_PROFILE_OPTION_VALUES
555: set PROFILE_OPTION_VALUE = 'N'
556: where APPLICATION_ID = 1292 and
557: -- LEVEL_ID = 10001 and
558: PROFILE_OPTION_ID in

Line 560: from FND_PROFILE_OPTIONS

556: where APPLICATION_ID = 1292 and
557: -- LEVEL_ID = 10001 and
558: PROFILE_OPTION_ID in
559: (select PROFILE_OPTION_ID
560: from FND_PROFILE_OPTIONS
561: where APPLICATION_ID = 1292 and
562: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
563:
564: commit;