APPS.EC_TRADING_PARTNER_PVT dependencies on HR_LOCATIONS

Line 771: from ece_tp_details tpd,hr_locations hrl

767: and hcp.contact_point_type = 'EDI';
768:
769: cursor type_location is
770: select tpd.tp_detail_id
771: from ece_tp_details tpd,hr_locations hrl
772: where tpd.tp_header_id = hrl.tp_header_id
773: and tpd.document_id = p_transaction_type
774: and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
775: and hrl.location_id = p_entity_id;