eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MASS_SEL_NOA dependencies on HR_ORGANIZATION_UNITS

Line 1606: l_org_name hr_organization_units.name%TYPE;

1602: l_elig_flag boolean DEFAULT FALSE;
1603: rec_busy EXCEPTION;
1604: PRAGMA EXCEPTION_INIT(rec_busy, -54);
1605: l_proc varchar2(72) DEFAULT g_package|| '.execute_mnoa';
1606: l_org_name hr_organization_units.name%TYPE;
1607: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
1608: ---Vacant position variables
1609: l_avail_status_id NUMBER;
1610: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;

Line 1635: , hr_organization_units hou

1631: , paf.assignment_status_type_id assignment_status_type_id
1632: FROM per_assignments_f paf
1633: , per_people_f ppf
1634: , per_person_types ppt
1635: , hr_organization_units hou
1636: , per_assignment_status_types past
1637: WHERE ppf.person_id = paf.person_id
1638: AND l_effective_date
1639: BETWEEN ppf.effective_start_date

Line 1678: , hr_organization_units hou

1674: , paf.assignment_status_type_id assignment_status_type_id
1675: FROM per_assignments_f paf
1676: , per_people_f ppf
1677: , per_person_types ppt
1678: , hr_organization_units hou
1679: , per_assignment_status_types past
1680: WHERE ppf.person_id = paf.person_id
1681: AND l_effective_date
1682: BETWEEN ppf.effective_start_date

Line 1718: , hr_organization_units hou

1714: , paf.assignment_status_type_id assignment_status_type_id
1715: FROM per_assignments_f paf
1716: , per_people_f ppf
1717: , per_person_types ppt
1718: , hr_organization_units hou
1719: , per_assignment_status_types past
1720: WHERE ppf.person_id = paf.person_id
1721: AND l_effective_date
1722: BETWEEN ppf.effective_start_date

Line 1758: , hr_organization_units hou

1754: , paf.assignment_status_type_id assignment_status_type_id
1755: FROM per_assignments_f paf
1756: , per_people_f ppf
1757: , per_person_types ppt
1758: , hr_organization_units hou
1759: , per_assignment_status_types past
1760: WHERE ppf.person_id = paf.person_id
1761: AND l_eff_date
1762: BETWEEN ppf.effective_start_date

Line 1798: , hr_organization_units hou

1794: , paf.assignment_status_type_id assignment_status_type_id
1795: FROM per_assignments_f paf
1796: , per_people_f ppf
1797: , per_person_types ppt
1798: , hr_organization_units hou
1799: , per_assignment_status_types past
1800: WHERE ppf.person_id = paf.person_id
1801: AND l_effective_date
1802: BETWEEN ppf.effective_start_date

Line 1838: , hr_organization_units hou

1834: , paf.assignment_status_type_id assignment_status_type_id
1835: FROM per_assignments_f paf
1836: , per_people_f ppf
1837: , per_person_types ppt
1838: , hr_organization_units hou
1839: , per_assignment_status_types past
1840: WHERE ppf.person_id = paf.person_id
1841: AND l_effective_date
1842: BETWEEN ppf.effective_start_date

Line 1879: , hr_organization_units hou

1875: , paf.assignment_status_type_id assignment_status_type_id
1876: FROM per_assignments_f paf
1877: , per_people_f ppf
1878: , per_person_types ppt
1879: , hr_organization_units hou
1880: WHERE ppf.person_id = paf.person_id
1881: AND l_effective_date
1882: BETWEEN ppf.effective_start_date
1883: AND ppf.effective_end_date