253: p_bg_id IN NUMBER) IS
254: SELECT DISTINCT ppa.payroll_action_id, hoi.organization_id, hou.name
255: FROM pay_payroll_actions ppa,
256: hr_organization_information hoi,
257: hr_all_organization_units hou
258: WHERE hoi.org_information_context = 'Canada Employer Identification'
259: AND hoi.org_information11 = p_trans
260: AND hou.business_group_id = p_bg_id
261: AND hou.organization_id = hoi.organization_id
266: ppa.legislative_parameters);
267: ----
268: CURSOR c_gre_name (b_org_id IN VARCHAR2) IS
269: SELECT hou.name
270: FROM hr_all_organization_units hou
271: WHERE hou.organization_id = to_number(b_org_id);
272: ----
273: /* Local variables */
274: l_trans_gre hr_all_organization_units.organization_id%TYPE;
270: FROM hr_all_organization_units hou
271: WHERE hou.organization_id = to_number(b_org_id);
272: ----
273: /* Local variables */
274: l_trans_gre hr_all_organization_units.organization_id%TYPE;
275: l_year VARCHAR2(10);
276: l_gre hr_all_organization_units.organization_id%TYPE;
277: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
278: l_trans_no ff_archive_items.value%TYPE;
272: ----
273: /* Local variables */
274: l_trans_gre hr_all_organization_units.organization_id%TYPE;
275: l_year VARCHAR2(10);
276: l_gre hr_all_organization_units.organization_id%TYPE;
277: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
278: l_trans_no ff_archive_items.value%TYPE;
279: l_tech_name ff_archive_items.value%TYPE;
280: l_tech_area ff_archive_items.value%TYPE;
273: /* Local variables */
274: l_trans_gre hr_all_organization_units.organization_id%TYPE;
275: l_year VARCHAR2(10);
276: l_gre hr_all_organization_units.organization_id%TYPE;
277: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
278: l_trans_no ff_archive_items.value%TYPE;
279: l_tech_name ff_archive_items.value%TYPE;
280: l_tech_area ff_archive_items.value%TYPE;
281: l_tech_phno ff_archive_items.value%TYPE;