APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 949: From zx_party_tax_profile

945: where application_id = c_application_id
946: and entity_code = c_entity_code
947: and event_class_code = c_event_class_code
948: and first_pty_org_id = (Select party_tax_profile_id
949: From zx_party_tax_profile
950: where party_id = c_org_id
951: and party_type_code = 'OU')
952: and c_trx_date >= effective_from
953: and c_trx_date <= nvl(effective_to,c_trx_date)

Line 1504: l_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

1500: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1501: RETURN VARCHAR2 IS
1502:
1503: l_cust_acct_site_id HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE;
1504: l_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1505: l_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
1506: l_tax_classification_code HZ_CUST_SITE_USES.tax_code%TYPE;
1507: l_ret_record_level VARCHAR2(30);
1508: l_return_status VARCHAR2(80);

Line 1511: l_parent_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

1507: l_ret_record_level VARCHAR2(30);
1508: l_return_status VARCHAR2(80);
1509: l_error_buffer VARCHAR2(100);
1510:
1511: l_parent_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1512: l_cust_account_id HZ_CUST_ACCT_SITES.CUST_ACCOUNT_ID%TYPE;
1513:
1514: CURSOR get_site_tax_info
1515: (c_site_use_id hz_cust_site_uses.site_use_id%TYPE,