APPS.PNP_UTIL_FUNC dependencies on PN_PAYMENT_ITEMS_ALL

Line 54: FROM pn_payment_items_all

50: l_org_id NUMBER(15);
51:
52: CURSOR amounts_cursor IS
53: SELECT actual_amount, accounted_amount, currency_code, due_date, rate, org_id
54: FROM pn_payment_items_all
55: WHERE payment_schedule_id = p_payment_schedule_id
56: AND payment_item_type_lookup_code = 'CASH';
57:
58: BEGIN

Line 139: FROM pn_payment_items_all ppi

135: BEGIN
136:
137: SELECT NVL(SUM(ppi.actual_amount),0)
138: INTO l_totalTermAmt
139: FROM pn_payment_items_all ppi
140: WHERE ppi.PAYMENT_TERM_ID = p_paymentTermId
141: AND ppi.payment_item_type_lookup_code = 'CASH';
142:
143: RETURN l_totalTermAmt;

Line 2782: pn_payment_items_all i

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
2786: WHERE lease_id = p_lease_ID

Line 2798: pn_payment_items_all i

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
2802: WHERE t.lease_id = p_lease_ID

Line 2815: pn_payment_items_all i

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
2819: WHERE t.lease_id = p_lease_ID

Line 2830: pn_payment_items_all i

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
2834: WHERE t.lease_id = p_lease_ID

Line 2845: pn_payment_items_all i

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
2849: WHERE t.lease_id = p_lease_ID

Line 2868: FROM pn_payment_items_all i

2864: FROM pn_payment_terms_all
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'

Line 2881: pn_payment_items_all i

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'
2885: AND s.lease_id = p_lease_ID;

Line 3214: FROM pn_payment_items_all item,

3210: l_item_end_dt DATE;
3211:
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

Line 3226: FROM pn_payment_items_all item,

3222: AND schd.payment_status_lookup_code = 'APPROVED';
3223:
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

Line 3238: FROM pn_payment_items_all item,

3234: AND schd.payment_status_lookup_code = 'APPROVED';
3235:
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

Line 3250: FROM pn_payment_items_all item,

3246: AND schd.payment_status_lookup_code = 'APPROVED';
3247:
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

Line 3262: FROM pn_payment_items_all item,

3258: AND schd.payment_status_lookup_code = 'APPROVED';
3259:
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

Line 8042: WHERE EXISTS (SELECT 'Y' FROM pn_payment_items_all

8038:
8039: CURSOR search_for_items (p_payment_term_id NUMBER) IS
8040: SELECT 'Y' answer
8041: FROM dual
8042: WHERE EXISTS (SELECT 'Y' FROM pn_payment_items_all
8043: WHERE payment_term_id = p_payment_term_id);
8044:
8045: BEGIN
8046: FOR chk_area IN get_lease_area LOOP

Line 8280: WHERE EXISTS (SELECT 'Y' FROM pn_payment_items_all

8276:
8277: CURSOR search_for_items (p_payment_term_id NUMBER) IS
8278: SELECT 'Y' answer
8279: FROM dual
8280: WHERE EXISTS (SELECT 'Y' FROM pn_payment_items_all
8281: WHERE payment_term_id = p_payment_term_id);
8282:
8283: -- note that the old office area is excluded
8284: CURSOR get_flr_area (p_as_of_date DATE) IS