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.PER_QH_MAINTAIN_QUERY dependencies on PER_PERSON_TYPE_USAGES_F

Line 126: per_person_type_usages_f pptuf

122: FROM
123: per_person_types_tl ppttl,
124: per_person_types ppt,
125: per_person_types ppt1,
126: per_person_type_usages_f pptuf
127: WHERE
128: pptuf.person_id = p_person_id
129: and l_effective_date between pptuf.effective_start_date and pptuf.effective_end_date
130: and ppt1.person_type_id = p_person_type_id

Line 139: per_person_type_usages_f ptu,

135: and ppttl.language = userenv('LANG');
136:
137: cursor csr_person_type_new_1(p_person_id number,l_effective_date date,p_system_person_type VARCHAR2) is
138: SELECT ptu.person_type_id FROM
139: per_person_type_usages_f ptu,
140: per_person_types ppt WHERE
141: ptu.person_id = p_person_id
142: and l_effective_date between ptu.effective_start_date and ptu.effective_end_date
143: and ptu.person_type_id = ppt.person_type_id and ppt.system_person_type=p_system_person_type;