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_APPLICATIONS_PKG dependencies on PER_PERSON_TYPE_USAGES

Line 2236: from per_person_type_usages_f ptu

2232:
2233: --changed for 2506446 from the old select
2234: cursor csr_ptu_row is
2235: select ptu.effective_start_date
2236: from per_person_type_usages_f ptu
2237: ,per_person_types ppt
2238: where ptu.person_id = p_person_id
2239: and ptu.effective_start_date > p_date_received
2240: and ptu.person_type_id = ppt.person_type_id

Line 2248: from per_person_type_usages_f ptu

2244: --Bug 3891787 Added the cursor to check for the person_type change
2245: cursor csr_ptu_row1
2246: is
2247: select ptu.person_type_id,ptu.effective_start_date
2248: from per_person_type_usages_f ptu
2249: where ptu.person_id = p_person_id
2250: and p_date_end+1 between ptu.effective_start_date and
2251: ptu.effective_start_date;
2252:

Line 2253: l_person_type_id per_person_type_usages.person_id%type;

2249: where ptu.person_id = p_person_id
2250: and p_date_end+1 between ptu.effective_start_date and
2251: ptu.effective_start_date;
2252:
2253: l_person_type_id per_person_type_usages.person_id%type;
2254: l_start_date date;
2255: l_date_end date;
2256: l_update_mode varchar2(30);
2257: