APPS.ZX_TCM_PTP_PKG dependencies on XLE_ENTITY_PROFILES

Line 304: FROM zx_party_tax_profile ptp, xle_entity_profiles xle

300: ELSIF P_Party_Type_Code = 'FIRST_PARTY' Then
301: -- Getting first party PTP
302: SELECT ptp.party_tax_profile_id
303: INTO p_ptp_id
304: FROM zx_party_tax_profile ptp, xle_entity_profiles xle
305: WHERE xle.legal_entity_id = p_le_id
306: AND ptp.party_id = xle.party_id
307: AND ptp.Party_Type_Code = p_party_type_code;
308:

Line 426: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,

422: OUTPUT Parameters: p_ptp_id - Party Tax Profile ID
423: p_return_status - Success is p_ptp_id is not null
424: ====================================================================== */
425: PROCEDURE GET_PTP_HQ(
426: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
427: p_ptp_id OUT NOCOPY zx_party_tax_profile.party_tax_profile_id%TYPE,
428: p_return_status OUT NOCOPY VARCHAR2)
429: IS
430: CURSOR c_get_ptp_id_hq

Line 531: xle_entity_profiles xle

527:
528: CURSOR c_ptp_of_le IS
529: SELECT ptp.party_tax_profile_id
530: FROM zx_party_tax_profile ptp,
531: xle_entity_profiles xle
532: WHERE xle.legal_entity_id = p_le_id
533: AND ptp.party_id = xle.party_id
534: AND ptp.Party_Type_Code = 'FIRST_PARTY';
535: