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.PN_SCHEDULES_ITEMS dependencies on PN_PAYMENT_TERMS_HISTORY

Line 5807: l_adj_type_code pn_payment_terms_history.adjustment_type_code%TYPE;

5803: p_mths NUMBER)
5804: IS
5805:
5806: l_term_hist_id NUMBER;
5807: l_adj_type_code pn_payment_terms_history.adjustment_type_code%TYPE;
5808: l_norm_str_dt DATE;
5809: l_lease_trmn_date DATE;
5810:
5811: CURSOR get_max_term_hist_cur(p_term_id IN NUMBER) IS

Line 5813: FROM pn_payment_terms_history

5809: l_lease_trmn_date DATE;
5810:
5811: CURSOR get_max_term_hist_cur(p_term_id IN NUMBER) IS
5812: SELECT term_history_id, adjustment_type_code
5813: FROM pn_payment_terms_history
5814: WHERE term_history_id = (SELECT max(pth.term_history_id)
5815: FROM pn_payment_terms_history pth
5816: WHERE pth.payment_term_id = p_term_id);
5817:

Line 5815: FROM pn_payment_terms_history pth

5811: CURSOR get_max_term_hist_cur(p_term_id IN NUMBER) IS
5812: SELECT term_history_id, adjustment_type_code
5813: FROM pn_payment_terms_history
5814: WHERE term_history_id = (SELECT max(pth.term_history_id)
5815: FROM pn_payment_terms_history pth
5816: WHERE pth.payment_term_id = p_term_id);
5817:
5818: BEGIN
5819: