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.PAY_JP_SOE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 478: from per_all_assignments_f paa

474: CURSOR csr_get_effective_date IS
475: select nvl( nvl( min(decode(greatest(least(p_effective_date,paa.effective_end_date), paa.effective_start_date),p_effective_date,p_effective_date)),
476: max(decode(greatest(paa.effective_end_date,p_effective_date),p_effective_date,paa.effective_end_date))),
477: min(decode(least(p_effective_date, paa.effective_start_date),p_effective_date, paa.effective_start_date)) ) EFFECTIVE_DATE
478: from per_all_assignments_f paa
479: where to_number(to_char(p_effective_date, 'YYYY'))
480: between to_number(to_char(paa.effective_start_date, 'YYYY'))
481: and to_number(to_char(paa.effective_end_date, 'YYYY'))
482: and paa.assignment_id = p_assignment_id;