APPS.PAY_FI_ARCHIVE_PSTA dependencies on HR_LOCATIONS

Line 197: from hr_organization_units hou, hr_locations hl

193: cursor csr_get_org_address (
194: p_organization_id number
195: ) is
196: select style, address_line_1, address_line_2, address_line_3, country, postal_code
197: from hr_organization_units hou, hr_locations hl
198: where hou.organization_id = p_organization_id and hou.location_id = hl.location_id;
199:
200: rl_get_org_address csr_get_org_address%rowtype;
201: rg_local_unit_details csr_local_unit_details%rowtype;

Line 204: l_postal_code hr_locations.postal_code%type;

200: rl_get_org_address csr_get_org_address%rowtype;
201: rg_local_unit_details csr_local_unit_details%rowtype;
202: l_action_info_id number;
203: l_ovn number;
204: l_postal_code hr_locations.postal_code%type;
205: l_country hr_locations.country%type;
206: l_payroll_name pay_payrolls_f.payroll_name%type;
207: begin
208: if g_debug then

Line 205: l_country hr_locations.country%type;

201: rg_local_unit_details csr_local_unit_details%rowtype;
202: l_action_info_id number;
203: l_ovn number;
204: l_postal_code hr_locations.postal_code%type;
205: l_country hr_locations.country%type;
206: l_payroll_name pay_payrolls_f.payroll_name%type;
207: begin
208: if g_debug then
209: hr_utility.set_location (' Entering Procedure RANGE_CODE', 10);