APPS.ZX_TCM_PTP_PKG dependencies on XLE_ETB_PROFILES

Line 69: ,xle_etb_profiles etb

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
72: /* added the below condition for Bug 4878175 */
73: AND ptp.party_type_code = p_party_type_code

Line 87: ,xle_etb_profiles etb

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
90: /* added the below condition for Bug 4878175 */
91: AND ptp.party_type_code = p_party_type_code

Line 105: ,xle_etb_profiles etb

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
108: /* added the below condition for Bug 4878175 */
109: AND ptp.party_type_code = p_party_type_code

Line 123: ,xle_etb_profiles etb

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
126: /* added the below condition for Bug 4878175 */
127: AND ptp.party_type_code = p_party_type_code

Line 434: xle_etb_profiles xlep

430: CURSOR c_get_ptp_id_hq
431: IS
432: SELECT party_tax_profile_id
433: FROM zx_party_tax_profile ptp,
434: xle_etb_profiles xlep
435: WHERE ptp.party_id = xlep.party_id
436: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
437: AND xlep.legal_entity_id = p_le_id
438: AND xlep.main_establishment_flag = 'Y';