APPS.POS_WCAPPROVE_PVT dependencies on HR_LOCATIONS_ALL_TL

Line 5281: l_deliver_to_location hr_locations_all_tl.location_code%type;

5277:
5278: FUNCTION GET_DELIVER_TO_LOCATION (p_wc_id IN NUMBER)
5279: RETURN VARCHAR2 IS
5280: l_count number;
5281: l_deliver_to_location hr_locations_all_tl.location_code%type;
5282: begin
5283:
5284: select count(*)
5285: into l_count

Line 5286: from hr_locations_all_tl hl,

5282: begin
5283:
5284: select count(*)
5285: into l_count
5286: from hr_locations_all_tl hl,
5287: po_distributions_all pod
5288: where pod.deliver_to_location_id = hl.location_id and
5289: hl.language (+) =userenv('LANG') and
5290: pod.po_distribution_id = p_wc_id;

Line 5298: from hr_locations_all_tl hl,

5294: return to_char(null);
5295: else
5296: select hl.location_code
5297: into l_deliver_to_location
5298: from hr_locations_all_tl hl,
5299: po_distributions_all pod
5300: where pod.deliver_to_location_id = hl.location_id and
5301: hl.language (+) =userenv('LANG') and
5302: pod.po_distribution_id = p_wc_id;