DBA Data[Home] [Help]

APPS.ZX_TAXWARE_USER_PKG dependencies on HZ_PARTIES

Line 2042: FROM hz_parties pty,

2038: ELSE
2039: BEGIN
2040: SELECT pty.party_number
2041: INTO arp_customer_code_tab(i)
2042: FROM hz_parties pty,
2043: zx_party_tax_profile ptp
2044: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2045: AND ptp.party_id = pty.party_id;
2046: EXCEPTION WHEN OTHERS THEN

Line 2074: FROM hz_parties pty,

2070: ELSE
2071: BEGIN
2072: SELECT pty.party_number
2073: INTO arp_customer_code_tab(i)
2074: FROM hz_parties pty,
2075: zx_party_tax_profile ptp
2076: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2077: AND ptp.party_id = pty.party_id;
2078: EXCEPTION WHEN OTHERS THEN

Line 2121: FROM hz_parties pty,

2117: IF g_line_negation THEN
2118: BEGIN
2119: SELECT pty.party_name
2120: INTO arp_customer_name_tab(i)
2121: FROM hz_parties pty,
2122: zx_party_tax_profile ptp
2123: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2124: AND ptp.party_id = pty.party_id;
2125: EXCEPTION WHEN OTHERS THEN

Line 2149: FROM hz_parties pty,

2145: THEN
2146: BEGIN
2147: SELECT pty.party_name
2148: INTO arp_customer_name_tab(i)
2149: FROM hz_parties pty,
2150: zx_party_tax_profile ptp
2151: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2152: AND ptp.party_id = pty.party_id;
2153: EXCEPTION WHEN OTHERS THEN