[Home] [Help]
171: p_document_type IN VARCHAR2) as
172:
173: CURSOR c_get_bus_grp_id(p_tax_unit_id IN NUMBER) IS
174: SELECT hou.business_group_id
175: FROM hr_organization_units hou
176: WHERE hou.organization_id = p_tax_unit_id;
177:
178: CURSOR c_get_bus_group_id(cp_assignment_action_id IN NUMBER) IS
179: SELECT paaf.business_group_id
190:
191: CURSOR c_get_employer_information(p_org_id IN NUMBER) IS
192: SELECT hou.name
193: ,hou.location_id
194: FROM hr_organization_units hou
195: ,hr_organization_information hoi
196: WHERE hou.organization_id = p_org_id
197: AND hoi.organization_id = hou.organization_id
198: AND hoi.org_information1 = 'HR_LEGAL';
199:
200: CURSOR c_get_org_info(cp_assignment_action_id IN NUMBER) IS
201: SELECT DISTINCT hou.name
202: ,hou.location_id
203: FROM hr_organization_units hou
204: ,hr_organization_information hoi
205: ,per_all_assignments_f paaf
206: ,pay_assignment_actions paa
207: WHERE paa.assignment_action_id = cp_assignment_action_id
268:
269: ln_tax_unit_id number;
270: ln_bus_grp_id number;
271: lv_legislation_code varchar2(3);
272: lv_org_name hr_organization_units.name%TYPE;
273: ln_location_id hr_organization_units.location_id%TYPE;
274: lv_address_line1 hr_locations.address_line_1%TYPE;
275: lv_address_line2 hr_locations.address_line_2%TYPE;
276: lv_address_line3 hr_locations.address_line_3%TYPE;
269: ln_tax_unit_id number;
270: ln_bus_grp_id number;
271: lv_legislation_code varchar2(3);
272: lv_org_name hr_organization_units.name%TYPE;
273: ln_location_id hr_organization_units.location_id%TYPE;
274: lv_address_line1 hr_locations.address_line_1%TYPE;
275: lv_address_line2 hr_locations.address_line_2%TYPE;
276: lv_address_line3 hr_locations.address_line_3%TYPE;
277: lv_town_or_city hr_locations.town_or_city%TYPE;