APPS.GHR_MASS_SEL_NOA dependencies on PER_PERSON_TYPES

Line 1634: , per_person_types ppt

1630: , paf.business_group_id business_group_id
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

Line 1677: , per_person_types ppt

1673: , paf.business_group_id business_group_id
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

Line 1717: , per_person_types ppt

1713: , paf.business_group_id business_group_id
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

Line 1757: , per_person_types ppt

1753: , paf.business_group_id business_group_id
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

Line 1797: , per_person_types ppt

1793: , paf.business_group_id business_group_id
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

Line 1837: , per_person_types ppt

1833: , paf.business_group_id business_group_id
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

Line 1878: , per_person_types ppt

1874: , paf.business_group_id business_group_id
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