APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on ZX_PARTY_TAX_PROFILE

Line 1350: (P_Party_ID IN zx_party_tax_profile.party_id%Type,

1346: * *
1347: * *
1348: **************************************************************************/
1349: FUNCTION Get_Default_Tax_Reg
1350: (P_Party_ID IN zx_party_tax_profile.party_id%Type,
1351: P_Party_Type IN zx_party_tax_profile.party_type_code%Type,
1352: P_Effective_Date IN zx_registrations.effective_from%Type,
1353: x_return_status OUT NOCOPY VARCHAR2
1354: )

Line 1351: P_Party_Type IN zx_party_tax_profile.party_type_code%Type,

1347: * *
1348: **************************************************************************/
1349: FUNCTION Get_Default_Tax_Reg
1350: (P_Party_ID IN zx_party_tax_profile.party_id%Type,
1351: P_Party_Type IN zx_party_tax_profile.party_type_code%Type,
1352: P_Effective_Date IN zx_registrations.effective_from%Type,
1353: x_return_status OUT NOCOPY VARCHAR2
1354: )
1355: RETURN Varchar2

Line 1366: ,zx_party_tax_profile ptp

1362:
1363: Cursor Default_Reg IS
1364: Select NVL(reg.registration_number, PTP.rep_registration_number) registration_number
1365: From zx_registrations reg
1366: ,zx_party_tax_profile ptp
1367: Where ptp.party_id = p_party_id
1368: AND ptp.party_type_code = p_party_type
1369: AND ptp.party_tax_profile_id = reg.party_tax_profile_id
1370: AND reg.default_registration_flag = 'Y'

Line 1376: From zx_party_tax_profile ptp

1372: AND (l_effective_date <= effective_to OR effective_to IS NULL);
1373:
1374: Cursor Reporting_Reg IS
1375: Select REP_REGISTRATION_NUMBER
1376: From zx_party_tax_profile ptp
1377: Where ptp.party_id = p_party_id
1378: AND ptp.party_type_code = p_party_type;
1379:
1380: Begin

Line 1493: p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type

1489: (
1490: x_return_status OUT NOCOPY VARCHAR2,
1491: p_registration_num IN ZX_REGISTRATIONS.Registration_Number%type,
1492: p_effective_date IN ZX_REGISTRATIONS.effective_from%type,
1493: p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type
1494: ) RETURN Number IS
1495: l_legal_entity_id NUMBER;
1496: BEGIN
1497: IF p_registration_num IS NOT NULL THEN

Line 1500: from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle

1496: BEGIN
1497: IF p_registration_num IS NOT NULL THEN
1498: SELECT distinct xle.legal_entity_id
1499: INTO l_legal_entity_id
1500: from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle
1501: where tr.registration_number = p_registration_num
1502: and tr.party_tax_profile_id = ptp.party_tax_profile_id
1503: and ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
1504: and ptp.party_id = xle.party_id;