DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on HR_LOCATIONS

Line 7339: l_ship_to_loc_id HR_LOCATIONS.ship_to_location_id%TYPE;

7335: d_module VARCHAR2(70) := 'po.plsql.PO_CORE_S.get_default_price';
7336: d_msg VARCHAR2(200);
7337:
7338: l_ret_sts VARCHAR2(1) := 'S';
7339: l_ship_to_loc_id HR_LOCATIONS.ship_to_location_id%TYPE;
7340:
7341: l_do_non_loc_cursor BOOLEAN;
7342:
7343: l_quantity NUMBER;

Line 7437: FROM hr_locations hrl

7433: BEGIN
7434:
7435: SELECT hrl.ship_to_location_id
7436: INTO l_ship_to_loc_id
7437: FROM hr_locations hrl
7438: WHERE hrl.location_id = p_deliver_to_loc_id;
7439:
7440: d_progress := 15;
7441: