APPS.PER_APPLICATIONS_PKG dependencies on PER_PERSON_TYPES

Line 901: FROM per_person_types PP

897: )
898: AND pap.effective_start_date = p_date_end + 1 -- If hired pap table has emp record with date_end+1
899: AND EXISTS
900: (SELECT 1
901: FROM per_person_types PP
902: WHERE pp.person_type_id = pap.person_type_id
903: AND PP.business_group_id + 0 = p_business_group_id
904: AND pp.active_flag ='Y'
905: AND pp.system_person_type IN ('EMP'));

Line 1259: FROM PER_PERSON_TYPE_USAGES_F PTU, PER_PERSON_TYPES PPT

1255: WHERE PAPF.PERSON_ID = P_PERSON_ID
1256: AND PAPF.EFFECTIVE_START_DATE > P_DATE_END + 1 ;
1257: cursor c2 is
1258: SELECT 1
1259: FROM PER_PERSON_TYPE_USAGES_F PTU, PER_PERSON_TYPES PPT
1260: WHERE PTU.PERSON_ID = P_PERSON_ID
1261: AND PTU.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID
1262: AND PPT.SYSTEM_PERSON_TYPE in ('EMP','CWK')
1263: AND PTU.EFFECTIVE_START_DATE > P_DATE_END + 1 ;

Line 2000: PER_PERSON_TYPES PPT,

1996: ,PAPF.GLOBAL_NAME
1997: ,PAPF.DATE_OF_DEATH
1998: -- End changes for bug 10245640
1999: FROM per_all_people_f PAPF,
2000: PER_PERSON_TYPES PPT,
2001: per_person_types PPT2
2002: WHERE PAPF.person_id = P_person_id
2003: AND PAPF.effective_end_date = P_date_end
2004: AND PPT.business_group_id = P_business_group_id

Line 2001: per_person_types PPT2

1997: ,PAPF.DATE_OF_DEATH
1998: -- End changes for bug 10245640
1999: FROM per_all_people_f PAPF,
2000: PER_PERSON_TYPES PPT,
2001: per_person_types PPT2
2002: WHERE PAPF.person_id = P_person_id
2003: AND PAPF.effective_end_date = P_date_end
2004: AND PPT.business_group_id = P_business_group_id
2005: and PAPF.business_group_id + 0 = P_Business_group_id

Line 2374: ,per_person_types ppt

2370: --changed for 2506446 from the old select
2371: cursor csr_ptu_row is
2372: select ptu.effective_start_date
2373: from per_person_type_usages_f ptu
2374: ,per_person_types ppt
2375: where ptu.person_id = p_person_id
2376: and ptu.effective_start_date > p_date_received
2377: and ptu.person_type_id = ppt.person_type_id
2378: and ppt.system_person_type = 'EX_APL'

Line 2442: from per_all_people_f per, per_person_types ppt

2438: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
2439:
2440: cursor fpt_person_rec is
2441: select effective_start_date,effective_end_date
2442: from per_all_people_f per, per_person_types ppt
2443: where person_id = p_person_id
2444: and per.person_type_id = ppt.person_type_id
2445: and effective_start_date > p_date_received
2446: order by effective_start_date;

Line 2450: from per_person_type_usages_f ptu, per_person_types ppt

2446: order by effective_start_date;
2447:
2448: cursor fpt_ptu_apl is
2449: select effective_start_date, ptu.person_type_id
2450: from per_person_type_usages_f ptu, per_person_types ppt
2451: where ptu.person_type_id = ppt.person_type_id
2452: and person_id = p_person_id
2453: and system_person_type in ('APL')
2454: and effective_start_date > p_date_received;