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 6786: l_adj_type_code pn_payment_terms_history.adjustment_type_code%TYPE;

6782: p_mths NUMBER)
6783: IS
6784:
6785: l_term_hist_id NUMBER;
6786: l_adj_type_code pn_payment_terms_history.adjustment_type_code%TYPE;
6787: l_norm_str_dt DATE;
6788: l_lease_trmn_date DATE;
6789:
6790: CURSOR get_max_term_hist_cur(p_term_id IN NUMBER) IS

Line 6792: FROM pn_payment_terms_history

6788: l_lease_trmn_date DATE;
6789:
6790: CURSOR get_max_term_hist_cur(p_term_id IN NUMBER) IS
6791: SELECT term_history_id, adjustment_type_code
6792: FROM pn_payment_terms_history
6793: WHERE term_history_id = (SELECT max(pth.term_history_id)
6794: FROM pn_payment_terms_history pth
6795: WHERE pth.payment_term_id = p_term_id);
6796:

Line 6794: FROM pn_payment_terms_history pth

6790: CURSOR get_max_term_hist_cur(p_term_id IN NUMBER) IS
6791: SELECT term_history_id, adjustment_type_code
6792: FROM pn_payment_terms_history
6793: WHERE term_history_id = (SELECT max(pth.term_history_id)
6794: FROM pn_payment_terms_history pth
6795: WHERE pth.payment_term_id = p_term_id);
6796:
6797: BEGIN
6798: