DBA Data[Home] [Help]

APPS.ZX_TAXWARE_USER_PKG dependencies on HZ_PARTIES

Line 2243: FROM hz_parties pty,

2239: ELSE
2240: BEGIN
2241: SELECT pty.party_number
2242: INTO arp_customer_code_tab(i)
2243: FROM hz_parties pty,
2244: zx_party_tax_profile ptp
2245: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2246: AND ptp.party_id = pty.party_id;
2247: EXCEPTION WHEN OTHERS THEN

Line 2275: FROM hz_parties pty,

2271: ELSE
2272: BEGIN
2273: SELECT pty.party_number
2274: INTO arp_customer_code_tab(i)
2275: FROM hz_parties pty,
2276: zx_party_tax_profile ptp
2277: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2278: AND ptp.party_id = pty.party_id;
2279: EXCEPTION WHEN OTHERS THEN

Line 2322: FROM hz_parties pty,

2318: IF g_line_negation THEN
2319: BEGIN
2320: SELECT pty.party_name
2321: INTO arp_customer_name_tab(i)
2322: FROM hz_parties pty,
2323: zx_party_tax_profile ptp
2324: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2325: AND ptp.party_id = pty.party_id;
2326: EXCEPTION WHEN OTHERS THEN

Line 2350: FROM hz_parties pty,

2346: THEN
2347: BEGIN
2348: SELECT pty.party_name
2349: INTO arp_customer_name_tab(i)
2350: FROM hz_parties pty,
2351: zx_party_tax_profile ptp
2352: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2353: AND ptp.party_id = pty.party_id;
2354: EXCEPTION WHEN OTHERS THEN