APPS.PQP_GB_PSI_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 48: g_person_dtl per_all_people_f%ROWTYPE;

44:
45: g_prev_assignment_id NUMBER := NULL;
46: g_prev_effective_date DATE;
47: g_prev_inclusion_flag VARCHAR2(1) := 'Y';
48: g_person_dtl per_all_people_f%ROWTYPE;
49: g_assignment_dtl per_all_assignments_f%ROWTYPE;
50:
51: -- 115.44.11511.1
52: -- For Penserver Performance

Line 309: from per_all_people_f papf

305: ,p_effective_date DATE
306: ,p_person_id NUMBER
307: ) IS
308: select *
309: from per_all_people_f papf
310: where papf.business_group_id = p_business_group_id
311: and papf.person_id = p_person_id
312: and p_effective_date
313: between papf.effective_start_date

Line 447: from per_all_people_f PER, per_periods_of_service PPS

443: select 'Y'
444: from dual
445: where
446: (select PPS.DATE_START -- DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
447: from per_all_people_f PER, per_periods_of_service PPS
448: where per.person_id = p_person_id
449: and pps.person_id = p_person_id
450: and p_effective_date
451: between per.effective_start_date

Line 505: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype

501: FUNCTION chk_penserver_basic_criteria
502: (p_business_group_id IN NUMBER
503: ,p_effective_date IN DATE
504: ,p_assignment_id IN NUMBER
505: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype
506: ,p_assignment_dtl OUT NOCOPY per_all_assignments_f%rowtype
507: ) RETURN VARCHAR2;
508:
509: /*