DBA Data[Home] [Help]

APPS.FTE_TRACKING_WRAPPER dependencies on HZ_PARTIES

Line 983: --select party_id into l_carrier_id from hz_parties where party_name = l_carrier_name;

979:
980: -- Select the carrier id for the carrier name passed through the XML
981: -- inner exception handling
982: BEGIN
983: --select party_id into l_carrier_id from hz_parties where party_name = l_carrier_name;
984: SELECT h.party_id INTO l_carrier_id
985: FROM hz_parties h, wsh_carriers w
986: WHERE h.party_id = w.carrier_id
987: AND party_name = l_carrier_name;

Line 985: FROM hz_parties h, wsh_carriers w

981: -- inner exception handling
982: BEGIN
983: --select party_id into l_carrier_id from hz_parties where party_name = l_carrier_name;
984: SELECT h.party_id INTO l_carrier_id
985: FROM hz_parties h, wsh_carriers w
986: WHERE h.party_id = w.carrier_id
987: AND party_name = l_carrier_name;
988: EXCEPTION
989: WHEN NO_DATA_FOUND THEN