DBA Data[Home] [Help]

APPS.HR_PERSON dependencies on PER_PERSON_TYPES

Line 2020: ,per_person_types ppt

2016: from sys.dual
2017: where exists(
2018: select 'Future Person Type exists'
2019: from per_people_f ppf
2020: ,per_person_types ppt
2021: ,per_startup_person_types pst
2022: where ppf.person_type_id = ppt.person_type_id
2023: and ppf.person_id = p_person_id
2024: and ppf.business_group_id +0 = ppt.business_group_id+0

Line 2096: per_person_types ppt ,

2092: (
2093: -- code change start for bug 3957689
2094: select 'Previous Person type exists'
2095: from per_all_people_f ppf ,
2096: per_person_types ppt ,
2097: per_startup_person_types pst ,
2098: per_person_type_usages_f ptu
2099: where ppf.person_id = p_person_id
2100: and ppf.business_group_id +0= p_business_group_id

Line 2125: ,per_person_types ppt

2121:
2122: /*
2123: select 'Previous Person type exists'
2124: from per_people_f ppf
2125: ,per_person_types ppt
2126: ,per_startup_person_types pst
2127: where ppf.person_type_id = ppt.person_type_id
2128: and ppf.person_id = p_person_id
2129: and ppf.business_group_id +0= ppt.business_group_id +0