eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TCM_PTP_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 60: FROM zx_party_tax_profile

56: IS
57: CURSOR c_get_ptp_id
58: IS
59: SELECT party_tax_profile_id
60: FROM zx_party_tax_profile
61: WHERE party_id = p_party_id
62: AND Party_Type_Code = p_party_type_code;
63:
64: CURSOR c_get_ptp_ou (Biz_Entity Number, p_construct VARCHAR2, p_type VARCHAR2, p_context VARCHAR2) IS

Line 68: ,zx_party_tax_profile ptp

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
72: /* added the below condition for Bug 4878175 */

Line 86: ,zx_party_tax_profile ptp

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
90: /* added the below condition for Bug 4878175 */

Line 104: ,zx_party_tax_profile ptp

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
108: /* added the below condition for Bug 4878175 */

Line 122: ,zx_party_tax_profile ptp

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
126: /* added the below condition for Bug 4878175 */

Line 317: FROM zx_party_tax_profile ptp, xle_entity_profiles xle

313: ELSIF P_Party_Type_Code = 'FIRST_PARTY' Then
314: -- Getting first party PTP
315: SELECT ptp.party_tax_profile_id
316: INTO p_ptp_id
317: FROM zx_party_tax_profile ptp, xle_entity_profiles xle
318: WHERE xle.legal_entity_id = p_le_id
319: AND ptp.party_id = xle.party_id
320: AND ptp.Party_Type_Code = p_party_type_code;
321:

Line 458: p_ptp_id OUT NOCOPY zx_party_tax_profile.party_tax_profile_id%TYPE,

454: p_return_status - Success is p_ptp_id is not null
455: ====================================================================== */
456: PROCEDURE GET_PTP_HQ(
457: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
458: p_ptp_id OUT NOCOPY zx_party_tax_profile.party_tax_profile_id%TYPE,
459: p_return_status OUT NOCOPY VARCHAR2)
460: IS
461: CURSOR c_get_ptp_id_hq
462: IS

Line 464: FROM zx_party_tax_profile ptp,

460: IS
461: CURSOR c_get_ptp_id_hq
462: IS
463: SELECT party_tax_profile_id
464: FROM zx_party_tax_profile ptp,
465: xle_etb_profiles xlep
466: WHERE ptp.party_id = xlep.party_id
467: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
468: AND xlep.legal_entity_id = p_le_id

Line 572: FROM zx_party_tax_profile

568: l_chk_le_flg VARCHAR2(1);
569:
570: CURSOR c_get_ptp IS
571: SELECT Use_Le_As_Subscriber_Flag, party_tax_profile_id
572: FROM zx_party_tax_profile
573: WHERE party_id = p_org_id
574: AND Party_Type_Code = 'OU';
575:
576: CURSOR c_ptp_of_le IS

Line 578: FROM zx_party_tax_profile ptp,

574: AND Party_Type_Code = 'OU';
575:
576: CURSOR c_ptp_of_le IS
577: SELECT ptp.party_tax_profile_id
578: FROM zx_party_tax_profile ptp,
579: xle_entity_profiles xle
580: WHERE xle.legal_entity_id = p_le_id
581: AND ptp.party_id = xle.party_id
582: AND ptp.Party_Type_Code = 'FIRST_PARTY';

Line 1600: P_PARTY_TYPE_CODE IN ZX_PARTY_TAX_PROFILE.PARTY_TYPE_CODE%TYPE,

1596: END SYNC_TAX_REGISTRATIONS;
1597:
1598: Procedure GET_PARTY_TAX_PROF_INFO(
1599: P_PARTY_ID IN NUMBER,
1600: P_PARTY_TYPE_CODE IN ZX_PARTY_TAX_PROFILE.PARTY_TYPE_CODE%TYPE,
1601: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
1602: X_RETURN_STATUS OUT NOCOPY VARCHAR2)
1603: IS
1604:

Line 1630: FROM zx_party_tax_profile ptp

1626: ptp.allow_offset_tax_flag,
1627: ptp.effective_from_use_le,
1628: ptp.rep_registration_number,
1629: ptp.rounding_rule_code
1630: FROM zx_party_tax_profile ptp
1631: WHERE ptp.party_id = p_party_id
1632: AND ptp.party_type_code = p_party_type_code;
1633:
1634: l_tbl_index binary_integer;

Line 1741: FROM zx_party_tax_profile ptp

1737: ptp.allow_offset_tax_flag,
1738: ptp.effective_from_use_le,
1739: ptp.rep_registration_number,
1740: ptp.rounding_rule_code
1741: FROM zx_party_tax_profile ptp
1742: WHERE party_tax_profile_id = p_party_tax_profile_id;
1743:
1744: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1745: l_tbl_index binary_integer;