APPS.ZX_AP_POPULATE_PKG dependencies on ZX_PARTY_TAX_PROFILE

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

994: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
995: l_tbl_index_party BINARY_INTEGER;
996: l_tbl_index_site BINARY_INTEGER;
997:
998: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile
999: --CURSOR ledger_cur (c_ledger_id ZX_REP_TRX_DETAIL_T.ledger_id%TYPE) IS
1000: -- SELECT name
1001: -- FROM gl_ledgers
1002: -- WHERE ledger_id = c_ledger_id

Line 1008: -- FROM zx_party_tax_profile

1004:
1005: -- CURSOR party_id_cur
1006: -- (c_bill_from_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE) IS
1007: -- SELECT party_id
1008: -- FROM zx_party_tax_profile
1009: -- WHERE PARTY_TAX_PROFILE_ID = c_bill_from_ptp_id
1010: -- AND party_type_code = 'THIRD_PARTY';
1011:
1012: -- CURSOR party_site_id_cur

Line 1015: -- FROM zx_party_tax_profile

1011:
1012: -- CURSOR party_site_id_cur
1013: -- (c_bill_from_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE) IS
1014: -- SELECT party_id
1015: -- FROM zx_party_tax_profile
1016: -- WHERE PARTY_TAX_PROFILE_ID = c_bill_from_stp_id
1017: -- AND party_type_code = 'THIRD_PARTY_SITE';
1018:
1019: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile

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

1015: -- FROM zx_party_tax_profile
1016: -- WHERE PARTY_TAX_PROFILE_ID = c_bill_from_stp_id
1017: -- AND party_type_code = 'THIRD_PARTY_SITE';
1018:
1019: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
1020: CURSOR party_reg_num_cur
1021: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
1022: SELECT rep_registration_number
1023: FROM zx_party_tax_profile

Line 1023: FROM zx_party_tax_profile

1019: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
1020: CURSOR party_reg_num_cur
1021: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
1022: SELECT rep_registration_number
1023: FROM zx_party_tax_profile
1024: WHERE party_id = c_bill_from_party_id
1025: AND party_type_code = 'THIRD_PARTY';
1026:
1027: CURSOR party_site_reg_num_cur

Line 1030: FROM zx_party_tax_profile

1026:
1027: CURSOR party_site_reg_num_cur
1028: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS
1029: SELECT rep_registration_number
1030: FROM zx_party_tax_profile
1031: WHERE party_id = c_bill_from_site_id
1032: AND party_type_code = 'THIRD_PARTY_SITE';
1033:
1034: CURSOR party_cur

Line 3651: ,zx_party_tax_profile ptp

3647: c_tax_date zx_lines.tax_date%TYPE
3648: ) IS
3649: SELECT ptp.rep_registration_number
3650: FROM xle_tax_associations rel
3651: ,zx_party_tax_profile ptp
3652: ,xle_etb_profiles etb
3653: WHERE rel.legal_construct_id = etb.establishment_id
3654: AND etb.party_id = ptp.party_id
3655: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'