APPS.ZX_AR_POPULATE_PKG dependencies on ZX_REGISTRATIONS

Line 3396: p_account_Type_Code zx_registrations.account_type_code%TYPE;

3392: l_tbl_index_cust BINARY_INTEGER;
3393: --Bug 5622686
3394: p_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3395: p_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3396: p_account_Type_Code zx_registrations.account_type_code%TYPE;
3397: p_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE;
3398: p_tax ZX_TAXES_B.TAX%TYPE;
3399: p_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
3400: p_jurisdiction_code ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;

Line 3401: p_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE;

3397: p_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE;
3398: p_tax ZX_TAXES_B.TAX%TYPE;
3399: p_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
3400: p_jurisdiction_code ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;
3401: p_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE;
3402: p_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE;
3403: p_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
3404: p_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
3405: p_ret_record_level VARCHAR2(100);

Line 3402: p_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE;

3398: p_tax ZX_TAXES_B.TAX%TYPE;
3399: p_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
3400: p_jurisdiction_code ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;
3401: p_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE;
3402: p_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE;
3403: p_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
3404: p_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
3405: p_ret_record_level VARCHAR2(100);
3406: p_return_status VARCHAR2(100);

Line 3428: zx_registrations reg

3424: CURSOR party_base_reg_num_cur
3425: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
3426: SELECT registration_number
3427: FROM zx_party_tax_profile ptp,
3428: zx_registrations reg
3429: WHERE ptp.party_id = c_party_id
3430: AND ptp.party_type_code = 'THIRD_PARTY'
3431: AND reg.party_tax_profile_id = ptp.party_tax_profile_id
3432: ORDER BY default_registration_flag DESC;

Line 3445: zx_registrations reg

3441: CURSOR party_site_base_reg_cur
3442: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
3443: SELECT registration_number
3444: FROM zx_party_tax_profile ptp,
3445: zx_registrations reg
3446: WHERE ptp.party_id = c_party_site_id
3447: AND ptp.party_type_code = 'THIRD_PARTY_SITE'
3448: AND reg.party_tax_profile_id = ptp.party_tax_profile_id
3449: ORDER BY default_registration_flag DESC;