APPS.PAY_MX_SUA_MAG dependencies on HR_ORGANIZATION_UNITS

Line 239: FROM hr_organization_units hou

235: ) RETURN varchar2 AS
236:
237: CURSOR c_get_bus_grp_id IS
238: SELECT hou.business_group_id
239: FROM hr_organization_units hou
240: WHERE hou.organization_id = p_gre_id;
241:
242: CURSOR c_get_imp_date(cp_organization_id IN NUMBER) IS
243: SELECT org_information6

Line 866: FROM hr_organization_units hou

862: AND organization_id = cp_gre_id;
863:
864: CURSOR c_get_bus_grp_id IS
865: SELECT hou.business_group_id
866: FROM hr_organization_units hou
867: WHERE hou.organization_id = g_mag_gre_id;
868:
869: l_proc_name varchar2(100);
870: lv_tran_type pay_action_information.action_information4%type;