APPS.PAY_CA_T4_MAG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 807: hr_all_organization_units hou

803: p_bg_id NUMBER) is
804: Select distinct ppa.payroll_action_id, hoi.organization_id, hou.name
805: From pay_payroll_actions ppa,
806: hr_organization_information hoi,
807: hr_all_organization_units hou
808: where hoi.org_information_context = 'Canada Employer Identification'
809: and hoi.org_information11 = p_trans
810: and hou.business_group_id = p_bg_id
811: and hou.organization_id = hoi.organization_id

Line 819: from hr_all_organization_units hou

815: and hoi.organization_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='));
816:
817: cursor c_gre_name (b_org_id VARCHAR2) is
818: select hou.name
819: from hr_all_organization_units hou
820: where hou.organization_id = to_number(b_org_id);
821:
822: /* Local variables */
823: l_trans_gre hr_all_organization_units.organization_id%TYPE;

Line 823: l_trans_gre hr_all_organization_units.organization_id%TYPE;

819: from hr_all_organization_units hou
820: where hou.organization_id = to_number(b_org_id);
821:
822: /* Local variables */
823: l_trans_gre hr_all_organization_units.organization_id%TYPE;
824: l_year VARCHAR2(10);
825: l_gre hr_all_organization_units.organization_id%TYPE;
826: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
827: l_trans_no VARCHAR2(240);

Line 825: l_gre hr_all_organization_units.organization_id%TYPE;

821:
822: /* Local variables */
823: l_trans_gre hr_all_organization_units.organization_id%TYPE;
824: l_year VARCHAR2(10);
825: l_gre hr_all_organization_units.organization_id%TYPE;
826: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
827: l_trans_no VARCHAR2(240);
828: l_tech_name VARCHAR2(240) ;
829: l_tech_area VARCHAR2(240) ;

Line 826: l_bus_grp hr_all_organization_units.business_group_id%TYPE;

822: /* Local variables */
823: l_trans_gre hr_all_organization_units.organization_id%TYPE;
824: l_year VARCHAR2(10);
825: l_gre hr_all_organization_units.organization_id%TYPE;
826: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
827: l_trans_no VARCHAR2(240);
828: l_tech_name VARCHAR2(240) ;
829: l_tech_area VARCHAR2(240) ;
830: l_tech_phno VARCHAR2(240) ;