APPS.WSH_CREATE_CARRIERS_PKG dependencies on WSH_CARRIERS_V

Line 508: FROM wsh_carriers_v

504: WHERE party_id = l_carrier_party_id;
505: -- Party Usage
506: CURSOR Get_Carrier_Status(l_carrier_party_id NUMBER) IS
507: SELECT active, party_usg_assignment_id
508: FROM wsh_carriers_v
509: WHERE carrier_id = l_carrier_party_id;
510:
511: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
512: l_party_usg_assignment_id NUMBER;

Line 865: FROM wsh_carriers_v

861:
862: --4708730
863: CURSOR get_carrier_details is
864: SELECT carrier_name,active
865: FROM wsh_carriers_v
866: WHERE carrier_id =P_Carrier_info.CARRIER_id;
867: Rec_carrier_details get_carrier_details%ROWTYPE;
868:
869: record_locked EXCEPTION;