APPS.PAY_IE_PAY_ADVICE_REPORT dependencies on HR_LOCATIONS_ALL

Line 13: from hr_locations_all

9: l_address_line_1 varchar2(150);
10: begin
11: hr_utility.trace('Entering ' ||g_package || 'get_address_line_1' );
12: select ADDRESS_LINE_1 into l_address_line_1
13: from hr_locations_all
14: where location_code = p_location_code and
15: nvl(BUSINESS_GROUP_ID,p_business_group_id) =
16: p_business_group_id;
17:

Line 35: from hr_locations_all

31: l_address_line_2 varchar2(150);
32: begin
33: hr_utility.trace('Entering ' ||g_package || 'get_address_line_2' );
34: select ADDRESS_LINE_2 into l_address_line_2
35: from hr_locations_all
36: where location_code = p_location_code and
37: nvl(BUSINESS_GROUP_ID,p_business_group_id) =
38: p_business_group_id;
39:

Line 57: from hr_locations_all

53: l_address_line_3 varchar2(150);
54: begin
55: hr_utility.trace('Entering ' ||g_package || 'get_address_line_3' );
56: select ADDRESS_LINE_3 into l_address_line_3
57: from hr_locations_all
58: where location_code = p_location_code and
59: nvl(BUSINESS_GROUP_ID,p_business_group_id) =
60: p_business_group_id;
61:

Line 83: from hr_locations_all,

79: begin
80:
81: hr_utility.trace('Entering ' ||g_package || 'get_region1' );
82: select HR_COUNTY.meaning into l_REGION_1
83: from hr_locations_all,
84: HR_LOOKUPS HR_COUNTY
85: where location_code = p_location_code and
86: nvl(BUSINESS_GROUP_ID,p_business_group_id) =
87: p_business_group_id AND

Line 109: from hr_locations_all

105: l_region_2 varchar2(150);
106: begin
107: hr_utility.trace('Entering ' ||g_package || 'get_region_2' );
108: select REGION_2 into l_region_2
109: from hr_locations_all
110: where location_code = p_location_code and
111: nvl(BUSINESS_GROUP_ID,p_business_group_id) =
112: p_business_group_id;
113:

Line 131: from hr_locations_all,

127: l_country varchar2(150);
128: begin
129: hr_utility.trace('Entering ' ||g_package || 'get_country' );
130: select TERRITORY_SHORT_NAME into l_country
131: from hr_locations_all,
132: FND_TERRITORIES_VL fnd_ter
133: where location_code = p_location_code and
134: nvl(BUSINESS_GROUP_ID,p_business_group_id) =
135: p_business_group_id and