APPS.CZ_BOM_SYNCH dependencies on CZ_DB_SETTINGS

Line 1560: FROM cz_db_settings

1556:
1557: BEGIN
1558:
1559: SELECT TO_NUMBER(value) INTO CommitBlockSize
1560: FROM cz_db_settings
1561: WHERE UPPER(setting_id) = COMMIT_BLOCK_SETTING_ID
1562: AND UPPER(section_name) = DBSETTINGS_SECTION_NAME;
1563:
1564: EXCEPTION

Line 1880: FROM cz_db_settings

1876: SELECT DECODE(UPPER(value), '1', 1, 'ON', 1, 'Y', 1, 'YES', 1,'TRUE', 1, 'ENABLE', 1,
1877: '0', 0, 'OFF', 0, 'N', 0, 'NO', 0,'FALSE', 0, 'DISABLE', 0,
1878: 1) --default value
1879: INTO VerifyItemProperties
1880: FROM cz_db_settings
1881: WHERE UPPER(setting_id) = VERIFY_PROPERTIES_SETTING_ID
1882: AND UPPER(section_name) = DBSETTINGS_SECTION_NAME;
1883:
1884: EXCEPTION

Line 1894: FROM cz_db_settings

1890:
1891: --Get the number of days from now after which a date is considered to be the epoch end date.
1892:
1893: SELECT TO_NUMBER(value) INTO DaysTillEpochEnd
1894: FROM cz_db_settings
1895: WHERE UPPER(setting_id) = DAYSTILLEPOCHEND_SETTING_ID
1896: AND UPPER(section_name) = DBSETTINGS_SECTION_NAME;
1897:
1898: EXCEPTION