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_PVT dependencies on PER_PEOPLE_F

Line 138: FROM PER_PEOPLE_F PPF, PER_PERSON_TYPES PPT

134:
135: CURSOR get_requested_name_ppf(c_requested_by_party_id NUMBER)
136: IS
137: SELECT PPF.FULL_NAME
138: FROM PER_PEOPLE_F PPF, PER_PERSON_TYPES PPT
139: WHERE PPF.PERSON_ID= c_requested_by_party_id
140: AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE
141: AND NVL(PPF.CURRENT_EMPLOYEE_FLAG, 'X') = 'Y'
142: AND PPF.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID

Line 994: FROM PER_PEOPLE_F PPF, PER_PERSON_TYPES PPT

990:
991: CURSOR get_requested_name_ppf(c_requested_by_party_id NUMBER)
992: IS
993: SELECT PPF.FULL_NAME
994: FROM PER_PEOPLE_F PPF, PER_PERSON_TYPES PPT
995: WHERE PPF.PERSON_ID= c_requested_by_party_id
996: AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE
997: AND NVL(PPF.CURRENT_EMPLOYEE_FLAG, 'X') = 'Y'
998: AND PPF.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID