APPS.PAY_MX_SUA_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 262: FROM hr_organization_information

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
262: FROM hr_organization_information
263: WHERE org_information_context = 'MX_TAX_REGISTRATION'
264: AND organization_id = cp_organization_id;
265:
266: CURSOR c_get_last_run_date IS

Line 975: FROM hr_organization_information

971: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
972:
973: CURSOR c_get_imp_date (cp_gre_id NUMBER) IS
974: SELECT org_information6
975: FROM hr_organization_information
976: WHERE org_information_context = 'MX_TAX_REGISTRATION'
977: AND organization_id = cp_gre_id;
978:
979: CURSOR c_get_bus_grp_id IS