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 PER_ASSIGNMENT_STATUS_TYPES

Line 960: per_assignment_status_types ast,

956:
957: cursor c_user_status is
958: select ast.user_status
959: from
960: per_assignment_status_types ast,
961: per_all_assignments_f asg
962: where asg.assignment_id = p_assignment_id
963: and ast.assignment_status_type_id = asg.assignment_status_type_id
964: and p_effective_date

Line 1636: , per_assignment_status_types past

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
1640: AND ppf.effective_end_date

Line 1679: , per_assignment_status_types past

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
1683: AND ppf.effective_end_date

Line 1719: , per_assignment_status_types past

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
1723: AND ppf.effective_end_date

Line 1759: , per_assignment_status_types past

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
1763: AND ppf.effective_end_date

Line 1799: , per_assignment_status_types past

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
1803: AND ppf.effective_end_date

Line 1839: , per_assignment_status_types past

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
1843: AND ppf.effective_end_date