DBA Data[Home] [Help]

APPS.ZX_AR_POPULATE_PKG dependencies on ZX_REGISTRATIONS

Line 3819: p_account_Type_Code zx_registrations.account_type_code%TYPE;

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;
3823: p_jurisdiction_code ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;

Line 3824: p_account_id ZX_REGISTRATIONS.ACCOUNT_ID%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;
3823: p_jurisdiction_code ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;
3824: p_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE;
3825: p_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE;
3826: p_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
3827: p_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
3828: p_ret_record_level VARCHAR2(100);

Line 3825: p_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE;

3821: p_tax ZX_TAXES_B.TAX%TYPE;
3822: p_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
3823: p_jurisdiction_code ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;
3824: p_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE;
3825: p_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE;
3826: p_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
3827: p_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
3828: p_ret_record_level VARCHAR2(100);
3829: p_return_status VARCHAR2(100);

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)