eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AR_POPULATE_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 3394: p_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

3390: l_tbl_index_bill_site BINARY_INTEGER;
3391: l_tbl_index_ship_site VARCHAR2(50);
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;

Line 3395: p_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

3391: l_tbl_index_ship_site VARCHAR2(50);
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;

Line 3415: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile

3411: FROM gl_ledgers
3412: WHERE ledger_id = c_ledger_id
3413: AND rownum = 1;
3414:
3415: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
3416:
3417: CURSOR party_reg_num_cur
3418: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
3419: SELECT rep_registration_number

Line 3420: FROM zx_party_tax_profile

3416:
3417: CURSOR party_reg_num_cur
3418: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
3419: SELECT rep_registration_number
3420: FROM zx_party_tax_profile
3421: WHERE party_id = c_party_id
3422: AND party_type_code = 'THIRD_PARTY';
3423:
3424: CURSOR party_base_reg_num_cur

Line 3427: FROM zx_party_tax_profile ptp,

3423:
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

Line 3437: FROM zx_party_tax_profile

3433:
3434: CURSOR party_site_reg_cur
3435: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
3436: SELECT rep_registration_number
3437: FROM zx_party_tax_profile
3438: WHERE party_id = c_party_site_id
3439: AND party_type_code = 'THIRD_PARTY_SITE';
3440:
3441: CURSOR party_site_base_reg_cur

Line 3444: FROM zx_party_tax_profile ptp,

3440:
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

Line 4187: ,zx_party_tax_profile ptp

4183: c_tax_date zx_lines.tax_date%TYPE
4184: ) IS
4185: SELECT ptp.rep_registration_number
4186: FROM xle_tax_associations rel
4187: ,zx_party_tax_profile ptp
4188: ,xle_etb_profiles etb
4189: WHERE rel.legal_construct_id = etb.establishment_id
4190: AND etb.party_id = ptp.party_id
4191: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'