APPS.PAY_NO_ABS_VALIDATION dependencies on PER_ALL_PEOPLE_F

Line 89: ,per_all_people_f papf

85:
86: CURSOR csr_get_org(c_person_id IN NUMBER) IS
87: SELECT hoi.organization_id org_id
88: FROM per_all_assignments_f paaf
89: ,per_all_people_f papf
90: ,hr_soft_coding_keyflex hsc
91: ,hr_organization_information hoi
92: WHERE papf.person_id = c_person_id
93: AND paaf.person_id = papf.person_id

Line 353: FROM per_all_people_f pap

349: ,pcr.contact_type
350: ,pcr.cont_information1
351: ,pcr.cont_information2
352: ,nvl(pcr.date_end,to_date('31-12-4712','DD-MM-YYYY')) date_end
353: FROM per_all_people_f pap
354: ,per_contact_relationships pcr
355: WHERE pap.person_id = pcr.contact_person_id
356: AND pcr.person_id = p_person_id
357: AND pcr.contact_type = p_contact_type

Line 548: FROM per_all_people_f pap

544: ,pcr.cont_information1
545: ,pcr.cont_information2
546: ,NVL(pcr.date_end,TO_DATE('31-12-4712','DD-MM-YYYY')) date_end
547: ,pcr.contact_relationship_id
548: FROM per_all_people_f pap
549: ,per_contact_relationships pcr
550: WHERE pap.person_id = pcr.contact_person_id
551: AND pcr.person_id = personid
552: AND pcr.contact_type = contacttype

Line 741: SELECT sex FROM per_all_people_f

737: ,P_ABSENCE_DAYS in NUMBER --#8510300
738: ,P_ABS_ATTENDANCE_REASON_ID in NUMBER) is
739:
740: CURSOR csr_get_gender(l_person_id NUMBER, l_date DATE) IS
741: SELECT sex FROM per_all_people_f
742: WHERE person_id = l_person_id
743: AND l_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
744:
745: -- Cursor to fetch global values

Line 754: SELECT start_date,PER_INFORMATION7 FROM per_all_people_f where

750: AND legislation_code = 'NO'
751: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
752:
753: CURSOR csr_get_person_hire_date(p_person_id number,p_effective_date date) IS
754: SELECT start_date,PER_INFORMATION7 FROM per_all_people_f where
755: person_id = p_person_id
756: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
757: AND EFFECTIVE_END_DATE;
758: