APPS.PAY_CA_T4_AMEND_MAG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 323: hr_all_organization_units hou

319: p_bg_id IN NUMBER) IS
320: SELECT DISTINCT ppa.payroll_action_id, hoi.organization_id, hou.name
321: FROM pay_payroll_actions ppa,
322: hr_organization_information hoi,
323: hr_all_organization_units hou
324: WHERE hoi.org_information_context = 'Canada Employer Identification'
325: AND hoi.org_information11 = p_trans
326: AND hou.business_group_id = p_bg_id
327: AND hou.organization_id = hoi.organization_id

Line 342: FROM hr_all_organization_units hou

338: +LENGTH('TRANSFER_GRE=')));
339: ----
340: CURSOR c_gre_name (b_org_id IN VARCHAR2) IS
341: SELECT hou.name
342: FROM hr_all_organization_units hou
343: WHERE hou.organization_id = to_number(b_org_id);
344: ----
345: /* Local variables */
346: l_trans_gre hr_all_organization_units.organization_id%TYPE;

Line 346: l_trans_gre hr_all_organization_units.organization_id%TYPE;

342: FROM hr_all_organization_units hou
343: WHERE hou.organization_id = to_number(b_org_id);
344: ----
345: /* Local variables */
346: l_trans_gre hr_all_organization_units.organization_id%TYPE;
347: l_year VARCHAR2(10);
348: l_gre hr_all_organization_units.organization_id%TYPE;
349: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
350: l_trans_no ff_archive_items.value%TYPE;

Line 348: l_gre hr_all_organization_units.organization_id%TYPE;

344: ----
345: /* Local variables */
346: l_trans_gre hr_all_organization_units.organization_id%TYPE;
347: l_year VARCHAR2(10);
348: l_gre hr_all_organization_units.organization_id%TYPE;
349: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
350: l_trans_no ff_archive_items.value%TYPE;
351: l_tech_name ff_archive_items.value%TYPE;
352: l_tech_area ff_archive_items.value%TYPE;

Line 349: l_bus_grp hr_all_organization_units.business_group_id%TYPE;

345: /* Local variables */
346: l_trans_gre hr_all_organization_units.organization_id%TYPE;
347: l_year VARCHAR2(10);
348: l_gre hr_all_organization_units.organization_id%TYPE;
349: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
350: l_trans_no ff_archive_items.value%TYPE;
351: l_tech_name ff_archive_items.value%TYPE;
352: l_tech_area ff_archive_items.value%TYPE;
353: l_tech_phno ff_archive_items.value%TYPE;