DBA Data[Home] [Help]

APPS.GHR_MASS_CON_PROGRAM dependencies on PER_PERSON_TYPES

Line 1891: per_person_types ppt,

1887: paf.business_group_id BUSINESS_GROUP_ID,
1888: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1889: FROM per_assignments_f paf,
1890: per_people_f ppf,
1891: per_person_types ppt,
1892: hr_organization_units hou
1893: WHERE ppf.person_id = paf.person_id
1894: AND l_eff_date between ppf.effective_start_date and ppf.effective_end_date
1895: AND l_eff_date between paf.effective_start_date and paf.effective_end_date

Line 1941: per_person_types ppt,

1937: paf.business_group_id BUSINESS_GROUP_ID,
1938: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1939: FROM per_assignments_f paf,
1940: per_people_f ppf,
1941: per_person_types ppt,
1942: hr_organization_units hou,
1943: per_assignment_status_types past
1944: WHERE ppf.person_id = paf.person_id
1945: AND l_eff_date between ppf.effective_start_date and ppf.effective_end_date