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_PERSON_TYPES

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 119: FROM per_all_people_f pap, per_person_types ppt

115: AND ppt.system_person_type ='EMP';
116: */
117: --Modified pjha 29-Aug-2002 for bug#2536490(added trim function)
118: SELECT person_id
119: FROM per_all_people_f pap, per_person_types ppt
120: WHERE trim(upper(FULL_NAME)) = upper(c_party_name)
121: AND trunc(sysdate) between pap.effective_start_date and pap.effective_end_date
122: AND nvl(pap.current_employee_flag,'x') = 'Y'
123: AND pap.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 754: FROM per_all_people_f pap, per_person_types ppt

750: AND ppt.system_person_type ='EMP';
751: */
752: --Modified pjha 29-Aug-2002 for bug#2536490(added trim function)
753: SELECT person_id
754: FROM per_all_people_f pap, per_person_types ppt
755: WHERE trim(upper(FULL_NAME)) = upper(c_party_name)
756: AND trunc(sysdate) between pap.effective_start_date and pap.effective_end_date
757: AND nvl(pap.current_employee_flag,'x') = 'Y'
758: AND pap.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'