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 822: FROM per_people_f ppf,per_person_types ppt

818: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L')
819: AND party_type = 'PERSON'
820: UNION
821: SELECT person_id
822: FROM per_people_f ppf,per_person_types ppt
823: WHERE upper(FULL_NAME) = upper(c_approved_by_pty_name)
824: AND trunc(sysdate) BETWEEN effective_start_date AND effective_end_date
825: AND nvl(current_employee_flag, 'X') = 'Y'
826: AND ppf.person_type_id = ppt.person_type_id

Line 848: FROM per_people_f ppf, per_person_types ppt

844: --Used to retrieve the party id for party name and party id
845: CURSOR get_party_name_id (c_party_name IN VARCHAR2, c_party_id IN NUMBER)
846: IS
847: SELECT person_id
848: FROM per_people_f ppf, per_person_types ppt
849: WHERE upper(FULL_NAME) = upper(c_party_name)
850: AND ppf.person_id = c_party_id
851: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
852: AND nvl(ppf.current_employee_flag,'x') = 'Y'