APPS.ZX_AP_POPULATE_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 859: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile

855: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
856: l_tbl_index_party BINARY_INTEGER;
857: l_tbl_index_site BINARY_INTEGER;
858:
859: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile
860: CURSOR ledger_cur (c_ledger_id ZX_REP_TRX_DETAIL_T.ledger_id%TYPE) IS
861: SELECT name
862: FROM gl_ledgers
863: WHERE ledger_id = c_ledger_id

Line 869: FROM zx_party_tax_profile

865:
866: /* CURSOR party_id_cur
867: (c_bill_from_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE) IS
868: SELECT party_id
869: FROM zx_party_tax_profile
870: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_ptp_id
871: AND party_type_code = 'THIRD_PARTY';
872:
873: CURSOR party_site_id_cur

Line 876: FROM zx_party_tax_profile

872:
873: CURSOR party_site_id_cur
874: (c_bill_from_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE) IS
875: SELECT party_id
876: FROM zx_party_tax_profile
877: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_stp_id
878: AND party_type_code = 'THIRD_PARTY_SITE';
879: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
880: */

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

875: SELECT party_id
876: FROM zx_party_tax_profile
877: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_stp_id
878: AND party_type_code = 'THIRD_PARTY_SITE';
879: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
880: */
881: CURSOR party_reg_num_cur
882: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
883: SELECT rep_registration_number

Line 884: FROM zx_party_tax_profile

880: */
881: CURSOR party_reg_num_cur
882: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
883: SELECT rep_registration_number
884: FROM zx_party_tax_profile
885: WHERE party_id = c_bill_from_party_id
886: AND party_type_code = 'THIRD_PARTY';
887:
888: CURSOR party_site_reg_num_cur

Line 891: FROM zx_party_tax_profile

887:
888: CURSOR party_site_reg_num_cur
889: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS
890: SELECT rep_registration_number
891: FROM zx_party_tax_profile
892: WHERE party_id = c_bill_from_site_id
893: AND party_type_code = 'THIRD_PARTY_SITE';
894:
895: CURSOR party_cur

Line 3161: ,zx_party_tax_profile ptp

3157: c_tax_date zx_lines.tax_date%TYPE
3158: ) IS
3159: SELECT ptp.rep_registration_number
3160: FROM xle_tax_associations rel
3161: ,zx_party_tax_profile ptp
3162: ,xle_etb_profiles etb
3163: WHERE rel.legal_construct_id = etb.establishment_id
3164: AND etb.party_id = ptp.party_id
3165: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'