APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PER_ALL_PEOPLE_F

Line 904: FROM PER_ALL_PEOPLE_F --

900: */
901:
902: SELECT full_name
903: INTO l_disp_name
904: FROM PER_ALL_PEOPLE_F --
905: WHERE person_id = l_id
906: AND trunc(sysdate) BETWEEN effective_start_date
907: AND effective_end_date;
908:

Line 1735: Per_All_People_f ppfs, --

1731: */
1732: CURSOR c1 (p_empid NUMBER, p_business_group_id NUMBER) IS
1733: SELECT pafe.supervisor_id
1734: FROM Per_All_Assignments_f pafe, --
1735: Per_All_People_f ppfs, --
1736: Per_All_Assignments_f pafs, --
1737: per_person_types_v ppts,
1738: per_person_type_usages_f pptu
1739: WHERE pafe.business_group_id = p_business_group_id

Line 1771: Per_All_People_f ppfs, --

1767: */
1768: CURSOR C2 ( p_empid NUMBER ) IS
1769: SELECT DISTINCT Pafe.supervisor_id
1770: FROM Per_All_Assignments_f pafe, --
1771: Per_All_People_f ppfs, --
1772: Per_All_Assignments_f pafs, --
1773: per_person_types_v ppts,
1774: per_person_type_usages_f pptu
1775: WHERE pafe.person_id = p_empid

Line 2017: FROM PER_ALL_PEOPLE_F CWK,

2013: AND HREC.employee_id = POEH.superior_id
2014: AND POEH.superior_level > 0
2015: UNION ALL
2016: SELECT poeh.superior_id, poeh.superior_level, cwk.full_name
2017: FROM PER_ALL_PEOPLE_F CWK,
2018: PO_EMPLOYEE_HIERARCHIES POEH,
2019: PER_ALL_ASSIGNMENTS_F A,
2020: PER_PERIODS_OF_SERVICE PS
2021: WHERE poeh.position_structure_id = p_approval_path_id

Line 2038: FROM PER_ALL_PEOPLE_F CWK,

2034: AND ( PS.ACTUAL_TERMINATION_DATE>= TRUNC(sysdate) OR PS.ACTUAL_TERMINATION_DATE IS NULL )
2035: UNION ALL
2036: SELECT
2037: POEH.SUPERIOR_ID , POEH.SUPERIOR_LEVEL, CWK.FULL_NAME
2038: FROM PER_ALL_PEOPLE_F CWK,
2039: PO_EMPLOYEE_HIERARCHIES POEH,
2040: PER_ALL_ASSIGNMENTS_F A,
2041: PER_PERIODS_OF_PLACEMENT PP
2042: WHERE poeh.position_structure_id = p_approval_path_id