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.HR_PERSON dependencies on PER_STARTUP_PERSON_TYPES

Line 2046: ,per_startup_person_types pst

2042: (
2043: SELECT 'Future Person Type exists'
2044: FROM per_person_type_usages_f ptu
2045: ,per_person_types ppt
2046: ,per_startup_person_types pst
2047: WHERE ptu.person_type_id = ppt.person_type_id
2048: AND ptu.person_id = p_person_id
2049: AND (
2050: p_effective_start_date < ptu.effective_start_date

Line 2067: ,per_startup_person_types pst

2063: where exists(
2064: select 'Future Person Type exists'
2065: from per_person_type_usages_f ptu
2066: ,per_person_types ppt
2067: ,per_startup_person_types pst
2068: where ptu.person_type_id = ppt.person_type_id
2069: and ptu.person_id = p_person_id
2070: and ((p_effective_start_date < ptu.effective_start_date)
2071: and p_check_all = 'Y')

Line 2150: ,per_startup_person_types pst

2146: where exists(
2147: select 'Future Person Type exists'
2148: from per_people_f ppf
2149: ,per_person_types ppt
2150: ,per_startup_person_types pst
2151: where ppf.person_type_id = ppt.person_type_id
2152: and ppf.person_id = p_person_id
2153: and ppf.business_group_id +0 = ppt.business_group_id+0
2154: and ppf.business_group_id +0 = p_business_group_id

Line 2182: ,per_startup_person_types pst

2178: where exists(
2179: select 'Future Person Type exists'
2180: from per_person_type_usages_f ptu
2181: ,per_person_types ppt
2182: ,per_startup_person_types pst
2183: where ptu.person_type_id = ppt.person_type_id
2184: and ptu.person_id = p_person_id
2185: and ((p_effective_start_date < ptu.effective_start_date)
2186: and p_check_all = 'Y')

Line 2248: per_startup_person_types pst ,

2244: -- code change start for bug 3957689
2245: select 'Previous Person type exists'
2246: from per_all_people_f ppf ,
2247: per_person_types ppt ,
2248: per_startup_person_types pst ,
2249: per_person_type_usages_f ptu
2250: where ppf.person_id = p_person_id
2251: and ppf.business_group_id +0= p_business_group_id
2252: and ppf.business_group_id +0= ppt.business_group_id +0

Line 2277: ,per_startup_person_types pst

2273: /*
2274: select 'Previous Person type exists'
2275: from per_people_f ppf
2276: ,per_person_types ppt
2277: ,per_startup_person_types pst
2278: where ppf.person_type_id = ppt.person_type_id
2279: and ppf.person_id = p_person_id
2280: and ppf.business_group_id +0= ppt.business_group_id +0
2281: and ppf.business_group_id +0= p_business_group_id