APPS.WSH_CREATE_CARRIERS_PKG dependencies on HZ_PARTIES

Line 503: FROM hz_parties

499: l_call_procedure varchar2(100);
500:
501: CURSOR Get_Object_Version_Number(l_carrier_party_id NUMBER) IS
502: SELECT object_version_number
503: FROM hz_parties
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

Line 1229: l_code_assignment_rec_type.owner_table_name := 'HZ_PARTIES';

1225: l_code_assignment_rec_type HZ_CLASSIFICATION_V2PUB.Code_Assignment_Rec_Type;
1226:
1227: BEGIN
1228:
1229: l_code_assignment_rec_type.owner_table_name := 'HZ_PARTIES';
1230: l_code_assignment_rec_type.owner_table_id := p_carrier_id;
1231: l_code_assignment_rec_type.created_by_module := 'ORACLE_SHIPPING';
1232: l_code_assignment_rec_type.class_category := 'TRANSPORTATION_PROVIDERS';
1233: l_code_assignment_rec_type.class_code := p_class_code;