APPS.WSH_CARRIERS_GRP dependencies on HZ_PARTIES

Line 42: FROM WSH_CARRIERS car, HZ_PARTIES par

38: IS
39:
40: CURSOR get_carrier_id(p_carrier_name VARCHAR2,fr_code VARCHAR2) is
41: SELECT carrier_id
42: FROM WSH_CARRIERS car, HZ_PARTIES par
43: WHERE car.carrier_id = par.PARTY_ID
44: AND par.PARTY_NAME = p_carrier_name
45: AND car.FREIGHT_CODE = fr_code;
46:

Line 1018: FROM WSH_CARRIERS car, HZ_PARTIES par

1014: AND enabled_flag = 'Y';
1015:
1016: CURSOR get_carrier_info(p_carrier_id NUMBER) IS
1017: SELECT car.freight_code,par.PARTY_NAME
1018: FROM WSH_CARRIERS car, HZ_PARTIES par
1019: WHERE car.carrier_id = p_carrier_id
1020: AND car.carrier_id = par.PARTY_ID;
1021:
1022: CURSOR get_org_carser_info(p_carrier_service_id NUMBER,p_org_id NUMBER) IS

Line 1659: FROM wsh_carriers, hz_parties

1655: ) IS
1656:
1657: CURSOR get_carrier_name IS
1658: SELECT party_name, freight_code
1659: FROM wsh_carriers, hz_parties
1660: WHERE carrier_id =party_id
1661: AND carrier_id= p_carrier_id;
1662:
1663: --