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 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 427: p_ptp_id OUT NOCOPY zx_party_tax_profile.party_tax_profile_id%TYPE,

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
431: IS

Line 433: FROM zx_party_tax_profile ptp,

429: IS
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

Line 524: FROM zx_party_tax_profile

520: l_chk_le_flg VARCHAR2(1);
521:
522: CURSOR c_get_ptp IS
523: SELECT Use_Le_As_Subscriber_Flag, party_tax_profile_id
524: FROM zx_party_tax_profile
525: WHERE party_id = p_org_id
526: AND Party_Type_Code = 'OU';
527:
528: CURSOR c_ptp_of_le IS

Line 530: FROM zx_party_tax_profile ptp,

526: AND Party_Type_Code = 'OU';
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';

Line 1459: P_PARTY_TYPE_CODE IN ZX_PARTY_TAX_PROFILE.PARTY_TYPE_CODE%TYPE,

1455: END SYNC_TAX_REGISTRATIONS;
1456:
1457: Procedure GET_PARTY_TAX_PROF_INFO(
1458: P_PARTY_ID IN NUMBER,
1459: P_PARTY_TYPE_CODE IN ZX_PARTY_TAX_PROFILE.PARTY_TYPE_CODE%TYPE,
1460: X_TBL_INDEX OUT NOCOPY BINARY_INTEGER,
1461: X_RETURN_STATUS OUT NOCOPY VARCHAR2)
1462: IS
1463:

Line 1489: FROM zx_party_tax_profile ptp

1485: ptp.allow_offset_tax_flag,
1486: ptp.effective_from_use_le,
1487: ptp.rep_registration_number,
1488: ptp.rounding_rule_code
1489: FROM zx_party_tax_profile ptp
1490: WHERE ptp.party_id = p_party_id
1491: AND ptp.party_type_code = p_party_type_code;
1492:
1493: l_tbl_index binary_integer;

Line 1600: FROM zx_party_tax_profile ptp

1596: ptp.allow_offset_tax_flag,
1597: ptp.effective_from_use_le,
1598: ptp.rep_registration_number,
1599: ptp.rounding_rule_code
1600: FROM zx_party_tax_profile ptp
1601: WHERE party_tax_profile_id = p_party_tax_profile_id;
1602:
1603: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1604: l_tbl_index binary_integer;