eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on PER_PEOPLE_F

Line 110: FROM per_people_f ppf, per_person_types ppt

106: IS
107: --Modified pjha 07-Aug-2002 for performance
108: /*
109: SELECT person_id
110: FROM per_people_f ppf, per_person_types ppt
111: WHERE upper(ppf.FULL_NAME) = upper(c_party_name)
112: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
113: AND nvl(ppf.current_employee_flag,'x') = 'Y'
114: AND ppf.person_type_id = ppt.person_type_id

Line 745: FROM per_people_f ppf, per_person_types ppt

741: IS
742: --Modified pjha 07-Aug-2002 for performance
743: /*
744: SELECT person_id
745: FROM per_people_f ppf, per_person_types ppt
746: WHERE upper(ppf.first_name||' '||ppf.last_name) = upper(c_party_name)
747: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
748: AND nvl(ppf.current_employee_flag,'x') = 'Y'
749: AND ppf.person_type_id = ppt.person_type_id

Line 769: FROM per_people_f ppf, per_person_types ppt

765: --Used to retrieve the party id for party name and party id
766: CURSOR get_party_name_id (c_party_name IN VARCHAR2, c_party_id IN NUMBER)
767: IS
768: SELECT person_id
769: FROM per_people_f ppf, per_person_types ppt
770: WHERE upper(FULL_NAME) = upper(c_party_name)
771: AND ppf.person_id = c_party_id
772: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
773: AND nvl(ppf.current_employee_flag,'x') = 'Y'