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.

[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 2427: FROM pn_payment_schedules_all

2423: BEGIN
2424: BEGIN
2425: SELECT MAX(schedule_date)
2426: INTO l_date
2427: FROM pn_payment_schedules_all
2428: WHERE payment_status_lookup_code = 'APPROVED'
2429: AND lease_id = p_leaseId;
2430:
2431: EXCEPTION

Line 2626: FROM pn_payment_schedules_all s,

2622: SELECT 1
2623: FROM dual
2624: WHERE EXISTS
2625: (SELECT 1
2626: FROM pn_payment_schedules_all s,
2627: pn_payment_items_all i
2628: WHERE i.payment_term_id IN
2629: (SELECT payment_term_id
2630: FROM pn_payment_terms_all

Line 2642: FROM pn_payment_schedules_all s,

2638: /* cursor for normalized used when called from lease */
2639:
2640: CURSOR max_appr_sched_norm(p_lease_ID IN NUMBER) IS
2641: SELECT MAX(s.schedule_date) AS schedule_date
2642: FROM pn_payment_schedules_all s,
2643: pn_payment_items_all i
2644: WHERE i.payment_term_id IN
2645: (SELECT t.payment_term_id
2646: FROM pn_payment_terms_all t

Line 2659: FROM pn_payment_schedules_all s,

2655:
2656: /* ONE TIME */
2657: CURSOR max_appr_sched_ot(p_lease_ID IN NUMBER) IS
2658: SELECT MAX(s.schedule_date) AS schedule_date
2659: FROM pn_payment_schedules_all s,
2660: pn_payment_items_all i
2661: WHERE i.payment_term_id IN
2662: (SELECT t.payment_term_id
2663: FROM pn_payment_terms_all t

Line 2674: FROM pn_payment_schedules_all s,

2670:
2671: /* MONTHLY */
2672: CURSOR max_appr_sched_mon(p_lease_ID IN NUMBER) IS
2673: SELECT MAX(s.schedule_date) AS schedule_date
2674: FROM pn_payment_schedules_all s,
2675: pn_payment_items_all i
2676: WHERE i.payment_term_id IN
2677: (SELECT t.payment_term_id
2678: FROM pn_payment_terms_all t

Line 2689: FROM pn_payment_schedules_all s,

2685:
2686: /* QUARTERLY, SEMI_ANNUAL, ANNUAL */
2687: CURSOR max_appr_sched_other(p_lease_ID IN NUMBER) IS
2688: SELECT MAX(s.schedule_date) AS schedule_date
2689: FROM pn_payment_schedules_all s,
2690: pn_payment_items_all i
2691: WHERE i.payment_term_id IN
2692: (SELECT t.payment_term_id
2693: FROM pn_payment_terms_all t

Line 2714: ,pn_payment_schedules_all s

2710: WHERE lease_ID = p_lease_ID
2711: AND payment_term_ID IN
2712: (SELECT DISTINCT i.payment_term_ID
2713: FROM pn_payment_items_all i
2714: ,pn_payment_schedules_all s
2715: WHERE s.schedule_date = p_sched_date
2716: AND s.lease_ID = p_lease_ID
2717: AND s.payment_status_lookup_code = 'APPROVED'
2718: AND i.payment_schedule_ID = s.payment_schedule_ID);

Line 2725: FROM pn_payment_schedules_all s,

2721: /* get the max schedule date for the term */
2722: CURSOR max_appr_sched_term( p_lease_ID IN NUMBER
2723: ,p_term_ID IN NUMBER) IS
2724: SELECT MAX(s.schedule_date) AS schedule_date
2725: FROM pn_payment_schedules_all s,
2726: pn_payment_items_all i
2727: WHERE i.payment_term_id = p_term_ID
2728: AND i.payment_schedule_id = s.payment_schedule_id
2729: AND s.payment_status_lookup_code = 'APPROVED'

Line 3009: FROM pn_payment_schedules_all

3005: maxDt DATE := TO_DATE('01/01/0001', 'MM/DD/YYYY');
3006:
3007: CURSOR csr_lst_appr_schd(p_lease_ID IN NUMBER) IS
3008: SELECT LAST_DAY(MAX(schedule_date)) AS last_appr_schd_month_end_dt
3009: FROM pn_payment_schedules_all
3010: WHERE payment_status_lookup_code = 'APPROVED'
3011: AND lease_id = p_lease_id;
3012:
3013:

Line 3061: pn_payment_schedules_all schd

3057: CURSOR csr_ot_item_end_date(p_term_id IN NUMBER) IS
3058: SELECT MAX(schedule_date) AS item_end_date
3059: FROM pn_payment_items_all item,
3060: pn_payment_terms_all term,
3061: pn_payment_schedules_all schd
3062: WHERE term.payment_term_id = p_term_id
3063: AND item.payment_term_id = term.payment_term_id
3064: AND item.payment_schedule_id = schd.payment_schedule_id
3065: AND item.payment_item_type_lookup_code = 'CASH'

Line 3073: pn_payment_schedules_all schd

3069: CURSOR csr_mon_item_end_date(p_term_id IN NUMBER) IS
3070: SELECT LAST_DAY(MAX(schedule_date)) AS item_end_date
3071: FROM pn_payment_items_all item,
3072: pn_payment_terms_all term,
3073: pn_payment_schedules_all schd
3074: WHERE term.payment_term_id = p_term_id
3075: AND item.payment_term_id = term.payment_term_id
3076: AND item.payment_schedule_id = schd.payment_schedule_id
3077: AND item.payment_item_type_lookup_code = 'CASH'

Line 3085: pn_payment_schedules_all schd

3081: CURSOR csr_qtr_item_end_date(p_term_id IN NUMBER) IS
3082: SELECT ADD_MONTHS(MAX(schedule_date),3) - 1 AS item_end_date
3083: FROM pn_payment_items_all item,
3084: pn_payment_terms_all term,
3085: pn_payment_schedules_all schd
3086: WHERE term.payment_term_id = p_term_id
3087: AND item.payment_term_id = term.payment_term_id
3088: AND item.payment_schedule_id = schd.payment_schedule_id
3089: AND item.payment_item_type_lookup_code = 'CASH'

Line 3097: pn_payment_schedules_all schd

3093: CURSOR csr_sa_item_end_date(p_term_id IN NUMBER) IS
3094: SELECT ADD_MONTHS(MAX(schedule_date),6) - 1 AS item_end_date
3095: FROM pn_payment_items_all item,
3096: pn_payment_terms_all term,
3097: pn_payment_schedules_all schd
3098: WHERE term.payment_term_id = p_term_id
3099: AND item.payment_term_id = term.payment_term_id
3100: AND item.payment_schedule_id = schd.payment_schedule_id
3101: AND item.payment_item_type_lookup_code = 'CASH'

Line 3109: pn_payment_schedules_all schd

3105: CURSOR csr_yr_item_end_date(p_term_id IN NUMBER) IS
3106: SELECT ADD_MONTHS(MAX(schedule_date),12) - 1 AS item_end_date
3107: FROM pn_payment_items_all item,
3108: pn_payment_terms_all term,
3109: pn_payment_schedules_all schd
3110: WHERE term.payment_term_id = p_term_id
3111: AND item.payment_term_id = term.payment_term_id
3112: AND item.payment_schedule_id = schd.payment_schedule_id
3113: AND item.payment_item_type_lookup_code = 'CASH'