DBA Data[Home] [Help]

APPS.ZX_RATES_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 480: FROM zx_party_tax_profile c

476: -- Getting the value of X_ORG_ID on the basis of X_CONTENT_OWNER_ID
477: -- and tax_type_code to be passed
478:
479: SELECT DECODE(c.party_type_code,'OU',c.party_id,-99) INTO X_ORG_ID
480: FROM zx_party_tax_profile c
481: WHERE c.party_tax_profile_id = X_CONTENT_OWNER_ID;
482:
483: BEGIN
484: SELECT TAX_TYPE_CODE INTO X_TAX_TYPE

Line 982: FROM zx_party_tax_profile c

978: -- Getting the value of X_ORG_ID on the basis of X_CONTENT_OWNER_ID
979: -- and tax_type_code to be passed
980:
981: SELECT decode(c.party_type_code,'OU',c.party_id,-99) INTO X_ORG_ID
982: FROM zx_party_tax_profile c
983: WHERE c.party_tax_profile_id = X_CONTENT_OWNER_ID;
984:
985: BEGIN
986: SELECT TAX_TYPE_CODE INTO X_TAX_TYPE