APPS.PAY_CA_T4A_AMEND_MAG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 334: hr_all_organization_units hou

330: p_bg_id IN NUMBER) IS
331: SELECT DISTINCT ppa.payroll_action_id, hoi.organization_id, hou.name
332: FROM pay_payroll_actions ppa,
333: hr_organization_information hoi,
334: hr_all_organization_units hou
335: WHERE hoi.org_information_context = 'Canada Employer Identification'
336: AND hoi.org_information11 = p_trans
337: AND hou.business_group_id = p_bg_id
338: AND hou.organization_id = hoi.organization_id

Line 353: FROM hr_all_organization_units hou

349: +LENGTH('TRANSFER_GRE=')));
350: ----
351: CURSOR c_gre_name (b_org_id IN VARCHAR2) IS
352: SELECT hou.name
353: FROM hr_all_organization_units hou
354: WHERE hou.organization_id = to_number(b_org_id);
355: ----
356: /* Local variables */
357: l_trans_gre hr_all_organization_units.organization_id%TYPE;

Line 357: l_trans_gre hr_all_organization_units.organization_id%TYPE;

353: FROM hr_all_organization_units hou
354: WHERE hou.organization_id = to_number(b_org_id);
355: ----
356: /* Local variables */
357: l_trans_gre hr_all_organization_units.organization_id%TYPE;
358: l_year VARCHAR2(10);
359: l_gre hr_all_organization_units.organization_id%TYPE;
360: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
361: l_trans_no VARCHAR2(240);

Line 359: l_gre hr_all_organization_units.organization_id%TYPE;

355: ----
356: /* Local variables */
357: l_trans_gre hr_all_organization_units.organization_id%TYPE;
358: l_year VARCHAR2(10);
359: l_gre hr_all_organization_units.organization_id%TYPE;
360: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
361: l_trans_no VARCHAR2(240);
362: l_tech_name VARCHAR2(240) ;
363: l_tech_area VARCHAR2(240) ;

Line 360: l_bus_grp hr_all_organization_units.business_group_id%TYPE;

356: /* Local variables */
357: l_trans_gre hr_all_organization_units.organization_id%TYPE;
358: l_year VARCHAR2(10);
359: l_gre hr_all_organization_units.organization_id%TYPE;
360: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
361: l_trans_no VARCHAR2(240);
362: l_tech_name VARCHAR2(240) ;
363: l_tech_area VARCHAR2(240) ;
364: l_tech_phno VARCHAR2(240) ;