APPS.ZX_TRN_VALIDATION_PKG dependencies on FND_LOOKUPS

Line 274: FROM fnd_lookups

270: -- Logging Infra: Statement level
271:
272: SELECT meaning
273: INTO x_party_type_token
274: FROM fnd_lookups
275: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
276: AND lookup_code = p_party_type_code;
277:
278: OPEN tax_reg_num_csr(p_tax_reg_num, p_party_type_code, p_tax_regime_code, p_tax, p_tax_jurisdiction_code);

Line 395: FROM fnd_lookups

391:
392: IF p_party_type_code = 'THIRD_PARTY' THEN
393: SELECT meaning
394: INTO x_party_type_token
395: FROM fnd_lookups
396: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
397: AND lookup_code = 'THIRD_PARTY_SITE';
398:
399: SELECT HZP.PARTY_NAME,

Line 447: FROM fnd_lookups

443: end if;
444: ELSIF p_party_type_code = 'THIRD_PARTY_SITE' THEN
445: SELECT meaning
446: INTO x_party_type_token
447: FROM fnd_lookups
448: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
449: AND lookup_code = 'THIRD_PARTY';
450:
451: SELECT HZP.PARTY_NAME

Line 666: FROM fnd_lookups

662: END IF;
663:
664: SELECT meaning
665: INTO x_party_type_token
666: FROM fnd_lookups
667: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
668: AND lookup_code = p_party_type_code;
669:
670: IF p_party_type_code = 'THIRD_PARTY' THEN

Line 831: FROM fnd_lookups

827: END IF;
828: IF l_total_count <> l_specific_count THEN
829: SELECT meaning
830: INTO x_party_type_token
831: FROM fnd_lookups
832: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
833: AND lookup_code = 'THIRD_PARTY_SITE';
834:
835: SELECT ZXP.PARTY_TAX_PROFILE_ID,HZP.PARTY_NAME,

Line 910: FROM fnd_lookups

906: END IF;
907: IF l_total_count <> l_specific_count THEN
908: SELECT meaning
909: INTO x_party_type_token
910: FROM fnd_lookups
911: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
912: AND lookup_code = 'THIRD_PARTY';
913:
914: SELECT ZXP.PARTY_TAX_PROFILE_ID,HZP.PARTY_NAME