APPS.PAY_CA_T4A_MAG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 462: hr_all_organization_units hou

458: p_bg_id NUMBER) is
459: Select distinct ppa.payroll_action_id, hoi.organization_id, hou.name
460: From pay_payroll_actions ppa,
461: hr_organization_information hoi,
462: hr_all_organization_units hou
463: where hoi.org_information_context = 'Canada Employer Identification'
464: and hoi.org_information11 = p_trans
465: and hou.business_group_id = p_bg_id
466: and hou.organization_id = hoi.organization_id

Line 474: from hr_all_organization_units hou

470: and hoi.organization_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='));
471:
472: cursor c_gre_name (b_org_id VARCHAR2) is
473: select hou.name
474: from hr_all_organization_units hou
475: where hou.organization_id = to_number(b_org_id);
476:
477: /* Local variables */
478: l_trans_gre hr_all_organization_units.organization_id%TYPE;

Line 478: l_trans_gre hr_all_organization_units.organization_id%TYPE;

474: from hr_all_organization_units hou
475: where hou.organization_id = to_number(b_org_id);
476:
477: /* Local variables */
478: l_trans_gre hr_all_organization_units.organization_id%TYPE;
479: l_year VARCHAR2(10);
480: l_gre hr_all_organization_units.organization_id%TYPE;
481: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
482: l_trans_no VARCHAR2(240);

Line 480: l_gre hr_all_organization_units.organization_id%TYPE;

476:
477: /* Local variables */
478: l_trans_gre hr_all_organization_units.organization_id%TYPE;
479: l_year VARCHAR2(10);
480: l_gre hr_all_organization_units.organization_id%TYPE;
481: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
482: l_trans_no VARCHAR2(240);
483: l_tech_name VARCHAR2(240) ;
484: l_tech_area VARCHAR2(240) ;

Line 481: l_bus_grp hr_all_organization_units.business_group_id%TYPE;

477: /* Local variables */
478: l_trans_gre hr_all_organization_units.organization_id%TYPE;
479: l_year VARCHAR2(10);
480: l_gre hr_all_organization_units.organization_id%TYPE;
481: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
482: l_trans_no VARCHAR2(240);
483: l_tech_name VARCHAR2(240) ;
484: l_tech_area VARCHAR2(240) ;
485: l_tech_phno VARCHAR2(240) ;