DBA Data[Home] [Help]

APPS.ZX_VTX_USER_PKG dependencies on HZ_PARTIES

Line 2105: FROM hz_parties pty,

2101: ELSE
2102: BEGIN
2103: SELECT pty.party_number
2104: INTO arp_customer_code_tab(i)
2105: FROM hz_parties pty,
2106: zx_party_tax_profile ptp
2107: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2108: AND ptp.party_id = pty.party_id;
2109: EXCEPTION WHEN OTHERS THEN

Line 2137: FROM hz_parties pty,

2133: ELSE
2134: BEGIN
2135: SELECT pty.party_number
2136: INTO arp_customer_code_tab(i)
2137: FROM hz_parties pty,
2138: zx_party_tax_profile ptp
2139: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2140: AND ptp.party_id = pty.party_id;
2141: EXCEPTION WHEN OTHERS THEN