APPS.ZX_AR_POPULATE_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 3817: p_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

3813: l_tbl_index_bill_site BINARY_INTEGER;
3814: l_tbl_index_ship_site VARCHAR2(50);
3815: l_tbl_index_cust BINARY_INTEGER;
3816: --Bug 5622686
3817: p_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3818: p_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3819: p_account_Type_Code zx_registrations.account_type_code%TYPE;
3820: p_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE;
3821: p_tax ZX_TAXES_B.TAX%TYPE;

Line 3818: p_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

3814: l_tbl_index_ship_site VARCHAR2(50);
3815: l_tbl_index_cust BINARY_INTEGER;
3816: --Bug 5622686
3817: p_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3818: p_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3819: p_account_Type_Code zx_registrations.account_type_code%TYPE;
3820: p_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE;
3821: p_tax ZX_TAXES_B.TAX%TYPE;
3822: p_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;

Line 3835: FROM zx_party_tax_profile ptp, zx_registrations reg

3831: CURSOR get_regnum_for_party (cp_party_type_code IN VARCHAR2
3832: ,cp_party_id IN NUMBER
3833: ,cp_trx_date IN DATE) IS
3834: SELECT NVL(ptp.rep_registration_number, reg.registration_number)
3835: FROM zx_party_tax_profile ptp, zx_registrations reg
3836: WHERE ptp.party_id = cp_party_id
3837: AND ptp.party_type_code = cp_party_type_code
3838: AND reg.party_tax_profile_id(+) = ptp.party_tax_profile_id
3839: AND cp_trx_date BETWEEN NVL(REG.EFFECTIVE_FROM,cp_trx_date)

Line 4584: ,zx_party_tax_profile ptp

4580: c_tax_date zx_lines.tax_date%TYPE
4581: ) IS
4582: SELECT ptp.rep_registration_number
4583: FROM xle_tax_associations rel
4584: ,zx_party_tax_profile ptp
4585: ,xle_etb_profiles etb
4586: WHERE rel.legal_construct_id = etb.establishment_id
4587: AND etb.party_id = ptp.party_id
4588: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'