APPS.AHL_DI_DOC_REVISION_PUB dependencies on PER_PEOPLE_F

Line 89: FROM per_people_f ppf,per_person_types ppt

85: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L')
86: AND party_type = 'PERSON'
87: UNION
88: SELECT person_id
89: FROM per_people_f ppf,per_person_types ppt
90: WHERE upper(FULL_NAME) = upper(c_approved_by_pty_name)
91: AND trunc(sysdate) BETWEEN effective_start_date AND effective_end_date
92: AND nvl(current_employee_flag, 'X') = 'Y'
93: AND ppf.person_type_id = ppt.person_type_id

Line 115: FROM per_people_f ppf, per_person_types ppt

111: --Used to retrieve the party id for party name and party id
112: CURSOR get_party_name_id (c_party_name IN VARCHAR2, c_party_id IN NUMBER)
113: IS
114: SELECT person_id
115: FROM per_people_f ppf, per_person_types ppt
116: WHERE upper(FULL_NAME) = upper(c_party_name)
117: AND ppf.person_id = c_party_id
118: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
119: AND nvl(ppf.current_employee_flag,'x') = 'Y'

Line 813: FROM per_people_f ppf,per_person_types ppt

809: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L')
810: AND party_type = 'PERSON'
811: UNION
812: SELECT person_id
813: FROM per_people_f ppf,per_person_types ppt
814: WHERE upper(FULL_NAME) = upper(c_approved_by_pty_name)
815: AND trunc(sysdate) BETWEEN effective_start_date AND effective_end_date
816: AND nvl(current_employee_flag, 'X') = 'Y'
817: AND ppf.person_type_id = ppt.person_type_id

Line 839: FROM per_people_f ppf, per_person_types ppt

835: --Used to retrieve the party id for party name and party id
836: CURSOR get_party_name_id (c_party_name IN VARCHAR2, c_party_id IN NUMBER)
837: IS
838: SELECT person_id
839: FROM per_people_f ppf, per_person_types ppt
840: WHERE upper(FULL_NAME) = upper(c_party_name)
841: AND ppf.person_id = c_party_id
842: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
843: AND nvl(ppf.current_employee_flag,'x') = 'Y'