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.PNP_UTIL_FUNC dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 2582: FROM pn_payment_schedules_all

2578: BEGIN
2579: BEGIN
2580: SELECT MAX(schedule_date)
2581: INTO l_date
2582: FROM pn_payment_schedules_all
2583: WHERE payment_status_lookup_code = 'APPROVED'
2584: AND lease_id = p_leaseId;
2585:
2586: EXCEPTION

Line 2781: FROM pn_payment_schedules_all s,

2777: SELECT 1
2778: FROM dual
2779: WHERE EXISTS
2780: (SELECT 1
2781: FROM pn_payment_schedules_all s,
2782: pn_payment_items_all i
2783: WHERE i.payment_term_id IN
2784: (SELECT payment_term_id
2785: FROM pn_payment_terms_all

Line 2797: FROM pn_payment_schedules_all s,

2793: /* cursor for normalized used when called from lease */
2794:
2795: CURSOR max_appr_sched_norm(p_lease_ID IN NUMBER) IS
2796: SELECT MAX(s.schedule_date) AS schedule_date
2797: FROM pn_payment_schedules_all s,
2798: pn_payment_items_all i
2799: WHERE i.payment_term_id IN
2800: (SELECT t.payment_term_id
2801: FROM pn_payment_terms_all t

Line 2814: FROM pn_payment_schedules_all s,

2810:
2811: /* ONE TIME */
2812: CURSOR max_appr_sched_ot(p_lease_ID IN NUMBER) IS
2813: SELECT MAX(s.schedule_date) AS schedule_date
2814: FROM pn_payment_schedules_all s,
2815: pn_payment_items_all i
2816: WHERE i.payment_term_id IN
2817: (SELECT t.payment_term_id
2818: FROM pn_payment_terms_all t

Line 2829: FROM pn_payment_schedules_all s,

2825:
2826: /* MONTHLY */
2827: CURSOR max_appr_sched_mon(p_lease_ID IN NUMBER) IS
2828: SELECT MAX(s.schedule_date) AS schedule_date
2829: FROM pn_payment_schedules_all s,
2830: pn_payment_items_all i
2831: WHERE i.payment_term_id IN
2832: (SELECT t.payment_term_id
2833: FROM pn_payment_terms_all t

Line 2844: FROM pn_payment_schedules_all s,

2840:
2841: /* QUARTERLY, SEMI_ANNUAL, ANNUAL */
2842: CURSOR max_appr_sched_other(p_lease_ID IN NUMBER) IS
2843: SELECT MAX(s.schedule_date) AS schedule_date
2844: FROM pn_payment_schedules_all s,
2845: pn_payment_items_all i
2846: WHERE i.payment_term_id IN
2847: (SELECT t.payment_term_id
2848: FROM pn_payment_terms_all t

Line 2869: ,pn_payment_schedules_all s

2865: WHERE lease_ID = p_lease_ID
2866: AND payment_term_ID IN
2867: (SELECT DISTINCT i.payment_term_ID
2868: FROM pn_payment_items_all i
2869: ,pn_payment_schedules_all s
2870: WHERE s.schedule_date = p_sched_date
2871: AND s.lease_ID = p_lease_ID
2872: AND s.payment_status_lookup_code = 'APPROVED'
2873: AND i.payment_schedule_ID = s.payment_schedule_ID);

Line 2880: FROM pn_payment_schedules_all s,

2876: /* get the max schedule date for the term */
2877: CURSOR max_appr_sched_term( p_lease_ID IN NUMBER
2878: ,p_term_ID IN NUMBER) IS
2879: SELECT MAX(s.schedule_date) AS schedule_date
2880: FROM pn_payment_schedules_all s,
2881: pn_payment_items_all i
2882: WHERE i.payment_term_id = p_term_ID
2883: AND i.payment_schedule_id = s.payment_schedule_id
2884: AND s.payment_status_lookup_code = 'APPROVED'

Line 3164: FROM pn_payment_schedules_all

3160: maxDt DATE := TO_DATE('01/01/0001', 'MM/DD/YYYY');
3161:
3162: CURSOR csr_lst_appr_schd(p_lease_ID IN NUMBER) IS
3163: SELECT LAST_DAY(MAX(schedule_date)) AS last_appr_schd_month_end_dt
3164: FROM pn_payment_schedules_all
3165: WHERE payment_status_lookup_code = 'APPROVED'
3166: AND lease_id = p_lease_id;
3167:
3168:

Line 3216: pn_payment_schedules_all schd

3212: CURSOR csr_ot_item_end_date(p_term_id IN NUMBER) IS
3213: SELECT MAX(schedule_date) AS item_end_date
3214: FROM pn_payment_items_all item,
3215: pn_payment_terms_all term,
3216: pn_payment_schedules_all schd
3217: WHERE term.payment_term_id = p_term_id
3218: AND item.payment_term_id = term.payment_term_id
3219: AND item.payment_schedule_id = schd.payment_schedule_id
3220: AND item.payment_item_type_lookup_code = 'CASH'

Line 3228: pn_payment_schedules_all schd

3224: CURSOR csr_mon_item_end_date(p_term_id IN NUMBER) IS
3225: SELECT LAST_DAY(MAX(schedule_date)) AS item_end_date
3226: FROM pn_payment_items_all item,
3227: pn_payment_terms_all term,
3228: pn_payment_schedules_all schd
3229: WHERE term.payment_term_id = p_term_id
3230: AND item.payment_term_id = term.payment_term_id
3231: AND item.payment_schedule_id = schd.payment_schedule_id
3232: AND item.payment_item_type_lookup_code = 'CASH'

Line 3240: pn_payment_schedules_all schd

3236: CURSOR csr_qtr_item_end_date(p_term_id IN NUMBER) IS
3237: SELECT ADD_MONTHS(MAX(schedule_date),3) - 1 AS item_end_date
3238: FROM pn_payment_items_all item,
3239: pn_payment_terms_all term,
3240: pn_payment_schedules_all schd
3241: WHERE term.payment_term_id = p_term_id
3242: AND item.payment_term_id = term.payment_term_id
3243: AND item.payment_schedule_id = schd.payment_schedule_id
3244: AND item.payment_item_type_lookup_code = 'CASH'

Line 3252: pn_payment_schedules_all schd

3248: CURSOR csr_sa_item_end_date(p_term_id IN NUMBER) IS
3249: SELECT ADD_MONTHS(MAX(schedule_date),6) - 1 AS item_end_date
3250: FROM pn_payment_items_all item,
3251: pn_payment_terms_all term,
3252: pn_payment_schedules_all schd
3253: WHERE term.payment_term_id = p_term_id
3254: AND item.payment_term_id = term.payment_term_id
3255: AND item.payment_schedule_id = schd.payment_schedule_id
3256: AND item.payment_item_type_lookup_code = 'CASH'

Line 3264: pn_payment_schedules_all schd

3260: CURSOR csr_yr_item_end_date(p_term_id IN NUMBER) IS
3261: SELECT ADD_MONTHS(MAX(schedule_date),12) - 1 AS item_end_date
3262: FROM pn_payment_items_all item,
3263: pn_payment_terms_all term,
3264: pn_payment_schedules_all schd
3265: WHERE term.payment_term_id = p_term_id
3266: AND item.payment_term_id = term.payment_term_id
3267: AND item.payment_schedule_id = schd.payment_schedule_id
3268: AND item.payment_item_type_lookup_code = 'CASH'