APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 496: FROM hr_all_organization_units

492: RETURN VARCHAR2 IS
493:
494: CURSOR c_get_bus_grp_id(cp_organization_id IN NUMBER) IS
495: SELECT business_group_id
496: FROM hr_all_organization_units
497: WHERE organization_id = cp_organization_id;
498:
499: CURSOR c_get_start_date(cp_tax_unit_id IN NUMBER) IS
500: SELECT pay_mx_utility.get_legi_param_val('END_DATE',LEGISLATIVE_PARAMETERS)

Line 4490: from hr_all_organization_units

4486:
4487: /*Begin - Bug 13357684*/
4488: select name
4489: into lv_gre_name
4490: from hr_all_organization_units
4491: where organization_id = ln_gre_id;
4492:
4493: lv_msg_txt := 'This Social Security Archiver was run for GRE '|| lv_gre_name || ' and period from ' || lv_start_date ||' to '|| lv_end_date;
4494: