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 316: from per_all_people_f papf

312: ,p_effective_date DATE
313: ,p_person_id NUMBER
314: ) IS
315: select *
316: from per_all_people_f papf
317: where papf.business_group_id = p_business_group_id
318: and papf.person_id = p_person_id
319: and p_effective_date
320: between papf.effective_start_date

Line 454: from per_all_people_f PER, per_periods_of_service PPS

450: select 'Y'
451: from dual
452: where
453: (select PPS.DATE_START -- DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
454: from per_all_people_f PER, per_periods_of_service PPS
455: where per.person_id = p_person_id
456: and pps.person_id = p_person_id
457: and p_effective_date
458: between per.effective_start_date

Line 512: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype

508: FUNCTION chk_penserver_basic_criteria
509: (p_business_group_id IN NUMBER
510: ,p_effective_date IN DATE
511: ,p_assignment_id IN NUMBER
512: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype
513: ,p_assignment_dtl OUT NOCOPY per_all_assignments_f%rowtype
514: ) RETURN VARCHAR2;
515:
516: /*