APPS.POS_WCAPPROVE_PVT dependencies on HR_LOCATIONS_ALL_TL

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;