APPS.PAY_MX_SUA_MAG dependencies on HR_ORGANIZATION_UNITS

Line 257: FROM hr_organization_units hou

253: ) RETURN varchar2 AS
254:
255: CURSOR c_get_bus_grp_id IS
256: SELECT hou.business_group_id
257: FROM hr_organization_units hou
258: WHERE hou.organization_id = p_gre_id;
259:
260: CURSOR c_get_imp_date(cp_organization_id IN NUMBER) IS
261: SELECT org_information6

Line 981: FROM hr_organization_units hou

977: AND organization_id = cp_gre_id;
978:
979: CURSOR c_get_bus_grp_id IS
980: SELECT hou.business_group_id
981: FROM hr_organization_units hou
982: WHERE hou.organization_id = g_mag_gre_id;
983:
984: l_proc_name varchar2(100);
985: lv_tran_type pay_action_information.action_information4%type;