DBA Data[Home] [Help]

APPS.ZX_TCM_PTP_PKG dependencies on XLE_TAX_ASSOCIATIONS

Line 67: FROM xle_tax_associations rel

63:
64: CURSOR c_get_ptp_ou (Biz_Entity Number, p_construct VARCHAR2, p_type VARCHAR2, p_context VARCHAR2) IS
65: SELECT ptp.party_tax_profile_id ptp_id
66: INTO p_ptp_id
67: FROM xle_tax_associations rel
68: ,zx_party_tax_profile ptp
69: ,xle_etb_profiles etb
70: WHERE rel.legal_construct_id = etb.establishment_id
71: AND etb.party_id = ptp.party_id

Line 85: FROM xle_tax_associations rel

81:
82: CURSOR c_get_ptp_inv_org (Biz_Entity Number, p_construct VARCHAR2, p_type VARCHAR2, p_context VARCHAR2) IS
83: SELECT ptp.party_tax_profile_id ptp_id
84: INTO p_ptp_id
85: FROM xle_tax_associations rel
86: ,zx_party_tax_profile ptp
87: ,xle_etb_profiles etb
88: WHERE rel.legal_construct_id = etb.establishment_id
89: AND etb.party_id = ptp.party_id

Line 103: FROM xle_tax_associations rel

99:
100: CURSOR c_get_ptp_stl (p_construct VARCHAR2, p_type VARCHAR2, p_context VARCHAR2) IS
101: SELECT ptp.party_tax_profile_id ptp_id
102: INTO p_ptp_id
103: FROM xle_tax_associations rel
104: ,zx_party_tax_profile ptp
105: ,xle_etb_profiles etb
106: WHERE rel.legal_construct_id = etb.establishment_id
107: AND etb.party_id = ptp.party_id

Line 121: FROM xle_tax_associations rel

117:
118: CURSOR c_get_ptp_invloc (p_construct VARCHAR2, p_type VARCHAR2, p_context VARCHAR2) IS
119: SELECT ptp.party_tax_profile_id ptp_id
120: INTO p_ptp_id
121: FROM xle_tax_associations rel
122: ,zx_party_tax_profile ptp
123: ,xle_etb_profiles etb
124: WHERE rel.legal_construct_id = etb.establishment_id
125: AND etb.party_id = ptp.party_id