APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on ZX_PARTY_TAX_PROFILE

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

1389: * *
1390: * *
1391: **************************************************************************/
1392: FUNCTION Get_Default_Tax_Reg
1393: (P_Party_ID IN zx_party_tax_profile.party_id%Type,
1394: P_Party_Type IN zx_party_tax_profile.party_type_code%Type,
1395: P_Effective_Date IN zx_registrations.effective_from%Type,
1396: x_return_status OUT NOCOPY VARCHAR2
1397: )

Line 1394: P_Party_Type IN zx_party_tax_profile.party_type_code%Type,

1390: * *
1391: **************************************************************************/
1392: FUNCTION Get_Default_Tax_Reg
1393: (P_Party_ID IN zx_party_tax_profile.party_id%Type,
1394: P_Party_Type IN zx_party_tax_profile.party_type_code%Type,
1395: P_Effective_Date IN zx_registrations.effective_from%Type,
1396: x_return_status OUT NOCOPY VARCHAR2
1397: )
1398: RETURN Varchar2

Line 1409: ,zx_party_tax_profile ptp

1405:
1406: Cursor Default_Reg IS
1407: Select NVL(reg.registration_number, PTP.rep_registration_number) registration_number
1408: From zx_registrations reg
1409: ,zx_party_tax_profile ptp
1410: Where ptp.party_id = p_party_id
1411: AND ptp.party_type_code = p_party_type
1412: AND ptp.party_tax_profile_id = reg.party_tax_profile_id
1413: AND reg.default_registration_flag = 'Y'

Line 1419: From zx_party_tax_profile ptp

1415: AND (l_effective_date <= effective_to OR effective_to IS NULL);
1416:
1417: Cursor Reporting_Reg IS
1418: Select REP_REGISTRATION_NUMBER
1419: From zx_party_tax_profile ptp
1420: Where ptp.party_id = p_party_id
1421: AND ptp.party_type_code = p_party_type;
1422:
1423: Begin

Line 1536: p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type

1532: (
1533: x_return_status OUT NOCOPY VARCHAR2,
1534: p_registration_num IN ZX_REGISTRATIONS.Registration_Number%type,
1535: p_effective_date IN ZX_REGISTRATIONS.effective_from%type,
1536: p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type
1537: ) RETURN Number IS
1538: l_legal_entity_id NUMBER;
1539: BEGIN
1540: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

1540: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1541: IF p_registration_num IS NOT NULL THEN
1542: SELECT distinct xle.legal_entity_id
1543: INTO l_legal_entity_id
1544: from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle
1545: where tr.registration_number = p_registration_num
1546: and tr.party_tax_profile_id = ptp.party_tax_profile_id
1547: and ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
1548: and ptp.party_id = xle.party_id;