APPS.PAY_CA_T4A_CANCEL_MAG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 254: hr_all_organization_units hou

250: p_bg_id IN NUMBER) IS
251: SELECT DISTINCT ppa.payroll_action_id, hoi.organization_id, hou.name
252: FROM pay_payroll_actions ppa,
253: hr_organization_information hoi,
254: hr_all_organization_units hou
255: WHERE hoi.org_information_context = 'Canada Employer Identification'
256: AND hoi.org_information11 = p_trans
257: AND hou.business_group_id = p_bg_id
258: AND hou.organization_id = hoi.organization_id

Line 267: FROM hr_all_organization_units hou

263: ppa.legislative_parameters);
264: ----
265: CURSOR c_gre_name (b_org_id IN VARCHAR2) IS
266: SELECT hou.name
267: FROM hr_all_organization_units hou
268: WHERE hou.organization_id = to_number(b_org_id);
269: ----
270: /* Local variables */
271: l_trans_gre hr_all_organization_units.organization_id%TYPE;

Line 271: l_trans_gre hr_all_organization_units.organization_id%TYPE;

267: FROM hr_all_organization_units hou
268: WHERE hou.organization_id = to_number(b_org_id);
269: ----
270: /* Local variables */
271: l_trans_gre hr_all_organization_units.organization_id%TYPE;
272: l_year VARCHAR2(10);
273: l_gre hr_all_organization_units.organization_id%TYPE;
274: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
275: l_trans_no VARCHAR2(240);

Line 273: l_gre hr_all_organization_units.organization_id%TYPE;

269: ----
270: /* Local variables */
271: l_trans_gre hr_all_organization_units.organization_id%TYPE;
272: l_year VARCHAR2(10);
273: l_gre hr_all_organization_units.organization_id%TYPE;
274: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
275: l_trans_no VARCHAR2(240);
276: l_tech_name VARCHAR2(240) ;
277: l_tech_area VARCHAR2(240) ;

Line 274: l_bus_grp hr_all_organization_units.business_group_id%TYPE;

270: /* Local variables */
271: l_trans_gre hr_all_organization_units.organization_id%TYPE;
272: l_year VARCHAR2(10);
273: l_gre hr_all_organization_units.organization_id%TYPE;
274: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
275: l_trans_no VARCHAR2(240);
276: l_tech_name VARCHAR2(240) ;
277: l_tech_area VARCHAR2(240) ;
278: l_tech_phno VARCHAR2(240) ;