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 8752: from hxc_recurring_periods hrp

8748: l_assign_end_date_flag Number := 0; /* Added the variable for bug 8528840 */
8749:
8750: cursor check_tc_period (p_rec_id number) is
8751: select hrp.period_type
8752: from hxc_recurring_periods hrp
8753: where hrp.recurring_period_id = p_rec_id;
8754: /* Added the cursor for bug 7584432 */
8755: Cursor get_termination_date(p_person_id number, p_stop_date DATE) is
8756: Select max(effective_end_date) from per_people_f