DBA Data[Home] [Help]

APPS.ZX_TRN_VALIDATION_PKG dependencies on FND_LOOKUPS

Line 251: FROM fnd_lookups

247: -- Logging Infra: Statement level
248:
249: SELECT meaning
250: INTO x_party_type_token
251: FROM fnd_lookups
252: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
253: AND lookup_code = p_party_type_code;
254:
255: OPEN tax_reg_num_csr(p_tax_reg_num, p_party_type_code, p_tax_regime_code, p_tax, p_tax_jurisdiction_code);

Line 372: FROM fnd_lookups

368:
369: IF p_party_type_code = 'THIRD_PARTY' THEN
370: SELECT meaning
371: INTO x_party_type_token
372: FROM fnd_lookups
373: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
374: AND lookup_code = 'THIRD_PARTY_SITE';
375:
376: SELECT HZP.PARTY_NAME,

Line 424: FROM fnd_lookups

420: end if;
421: ELSIF p_party_type_code = 'THIRD_PARTY_SITE' THEN
422: SELECT meaning
423: INTO x_party_type_token
424: FROM fnd_lookups
425: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
426: AND lookup_code = 'THIRD_PARTY';
427:
428: SELECT HZP.PARTY_NAME