APPS.POS_WCAPPROVE_PVT dependencies on HR_LOCATIONS_ALL

Line 3781: X_location_code hr_locations_all.location_code%TYPE;

3777:
3778: X_emp_id number;
3779: X_emp_name per_employees_current_x.full_name%TYPE;
3780: X_location_id number;
3781: X_location_code hr_locations_all.location_code%TYPE;
3782: X_is_buyer BOOLEAN;
3783: X_emp_flag BOOLEAN;
3784: l_emp_ok BOOLEAN;
3785: l_uom_code mtl_units_of_measure.uom_code%type;

Line 4954: l_deliver_to_location hr_locations_all_tl.location_code%type;

4950:
4951: FUNCTION GET_DELIVER_TO_LOCATION (p_wc_id IN NUMBER)
4952: RETURN VARCHAR2 IS
4953: l_count number;
4954: l_deliver_to_location hr_locations_all_tl.location_code%type;
4955: begin
4956:
4957: select count(*)
4958: into l_count

Line 4959: from hr_locations_all_tl hl,

4955: begin
4956:
4957: select count(*)
4958: into l_count
4959: from hr_locations_all_tl hl,
4960: po_distributions_all pod
4961: where pod.deliver_to_location_id = hl.location_id and
4962: hl.language (+) =userenv('LANG') and
4963: pod.po_distribution_id = p_wc_id;

Line 4971: from hr_locations_all_tl hl,

4967: return to_char(null);
4968: else
4969: select hl.location_code
4970: into l_deliver_to_location
4971: from hr_locations_all_tl hl,
4972: po_distributions_all pod
4973: where pod.deliver_to_location_id = hl.location_id and
4974: hl.language (+) =userenv('LANG') and
4975: pod.po_distribution_id = p_wc_id;