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.PA_OTC_API dependencies on HXC_RECURRING_PERIODS

Line 7868: from hxc_recurring_periods hrp

7864: l_termination_date Date := Null; /* Added the variable for bug 7584432 */
7865:
7866: cursor check_tc_period (p_rec_id number) is
7867: select hrp.period_type
7868: from hxc_recurring_periods hrp
7869: where hrp.recurring_period_id = p_rec_id;
7870: /* Added the cursor for bug 7584432 */
7871: Cursor get_termination_date(p_person_id number, p_stop_date DATE) is
7872: Select max(effective_end_date) from per_people_f