APPS.POS_BATCH_IMPORT_PKG dependencies on FND_LOOKUPS

Line 6004: FROM fnd_lookups fndlookup

6000: fnd_file.put_line(fnd_file.log, ' Validating rounding level');
6001: BEGIN
6002: SELECT fndlookup.lookup_code
6003: INTO l_dummy_lookup
6004: FROM fnd_lookups fndlookup
6005: WHERE fndlookup.lookup_type LIKE 'ZX_ROUNDING_LEVEL'
6006: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6007: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6008: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'

Line 6048: FROM fnd_lookups fndlookup

6044: fnd_file.put_line(fnd_file.log, ' Validating rounding rule');
6045: BEGIN
6046: SELECT fndlookup.lookup_code
6047: INTO l_dummy_lookup
6048: FROM fnd_lookups fndlookup
6049: WHERE fndlookup.lookup_type LIKE 'ZX_ROUNDING_RULE'
6050: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6051: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6052: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'

Line 6132: FROM fnd_lookups fndlookup

6128: fnd_file.put_line(fnd_file.log, ' Validating registration type');
6129: BEGIN
6130: SELECT fndlookup.lookup_code
6131: INTO l_dummy_lookup
6132: FROM fnd_lookups fndlookup
6133: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_TYPE'
6134: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6135: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6136: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'

Line 6391: FROM fnd_lookups fndlookup

6387: fnd_file.put_line(fnd_file.log,
6388: ' Validating tax registration type');
6389: SELECT fndlookup.lookup_code
6390: INTO l_dummy_lookup
6391: FROM fnd_lookups fndlookup
6392: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_TYPE'
6393: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6394: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6395: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'

Line 6436: FROM fnd_lookups fndlookup

6432: ' Validating tax registration status');
6433: BEGIN
6434: SELECT fndlookup.lookup_code
6435: INTO l_dummy_lookup
6436: FROM fnd_lookups fndlookup
6437: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_STATUS'
6438: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6439: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6440: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'

Line 6527: FROM fnd_lookups fndlookup

6523: ' Validating tax registration reason code');
6524: BEGIN
6525: SELECT fndlookup.lookup_code
6526: INTO l_dummy_lookup
6527: FROM fnd_lookups fndlookup
6528: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_REASON'
6529: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6530: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6531: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'

Line 6572: FROM fnd_lookups fndlookup

6568: ' Validating tax registration source code');
6569: BEGIN
6570: SELECT fndlookup.lookup_code
6571: INTO l_dummy_lookup
6572: FROM fnd_lookups fndlookup
6573: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_SOURCE'
6574: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6575: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6576: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'

Line 6617: FROM fnd_lookups fndlookup

6613: ' Validating tax registration rounding rule code');
6614: BEGIN
6615: SELECT fndlookup.lookup_code
6616: INTO l_dummy_lookup
6617: FROM fnd_lookups fndlookup
6618: WHERE fndlookup.lookup_type LIKE 'ZX_ROUNDING_RULE'
6619: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6620: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6621: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'