DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on HR_LOCATIONS

Line 7547: l_ship_to_loc_id HR_LOCATIONS.ship_to_location_id%TYPE;

7543: d_module VARCHAR2(70) := 'po.plsql.PO_CORE_S.get_default_price';
7544: d_msg VARCHAR2(200);
7545:
7546: l_ret_sts VARCHAR2(1) := 'S';
7547: l_ship_to_loc_id HR_LOCATIONS.ship_to_location_id%TYPE;
7548:
7549: l_do_non_loc_cursor BOOLEAN;
7550:
7551: l_quantity NUMBER;

Line 7645: FROM hr_locations hrl

7641: BEGIN
7642:
7643: SELECT hrl.ship_to_location_id
7644: INTO l_ship_to_loc_id
7645: FROM hr_locations hrl
7646: WHERE hrl.location_id = p_deliver_to_loc_id;
7647:
7648: d_progress := 15;
7649: