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.PN_MASS_APPR_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 83: FROM pn_payment_items_all

79: ,actual_amount
80: ,currency_code
81: ,due_date
82: ,rate
83: FROM pn_payment_items_all
84: WHERE payment_schedule_id = p_schedule_id
85: AND payment_item_type_lookup_code = 'CASH';
86:
87: CURSOR norm_cursor( p_term_id IN NUMBER

Line 93: FROM pn_payment_items_all pi

89: SELECT pi.payment_item_id
90: ,pi.accounted_amount
91: ,pi.actual_amount
92: ,pi.currency_code
93: FROM pn_payment_items_all pi
94: ,pn_payment_items_all pi1
95: WHERE pi.payment_schedule_id = p_schedule_id
96: AND pi.payment_term_id = p_term_id
97: AND pi.payment_item_type_lookup_code = 'NORMALIZED'

Line 94: ,pn_payment_items_all pi1

90: ,pi.accounted_amount
91: ,pi.actual_amount
92: ,pi.currency_code
93: FROM pn_payment_items_all pi
94: ,pn_payment_items_all pi1
95: WHERE pi.payment_schedule_id = p_schedule_id
96: AND pi.payment_term_id = p_term_id
97: AND pi.payment_item_type_lookup_code = 'NORMALIZED'
98: AND pi1.payment_schedule_id = pi.payment_schedule_id

Line 299: FROM pn_payment_items_all item

295: AND ploc.location_code >= NVL(p_location_from_code, ploc.location_code)
296: AND ploc.location_code <= NVL(p_location_to_code, ploc.location_code)
297: AND EXISTS
298: (SELECT NULL
299: FROM pn_payment_items_all item
300: WHERE item.payment_schedule_id = pps.payment_schedule_id
301: AND item.due_date BETWEEN NVL(p_trx_from_date, item.due_date)
302: AND NVL(p_trx_to_date, item.due_date)
303: )

Line 332: FROM pn_payment_items_all item

328: AND pld.lease_id = pps.lease_id
329: AND pld.responsible_user = NVL(p_responsible_user, pld.responsible_user)
330: AND EXISTS
331: (SELECT NULL
332: FROM pn_payment_items_all item
333: WHERE item.payment_schedule_id = pps.payment_schedule_id
334: AND item.due_date BETWEEN NVL(p_trx_from_date, item.due_date)
335: AND NVL(p_trx_to_date, item.due_date)
336: )

Line 356: pn_payment_items_all ppi

352: SELECT 'Y'
353: FROM DUAL
354: WHERE EXISTS (SELECT NULL
355: FROM pn_payment_terms_all ppt,
356: pn_payment_items_all ppi
357: WHERE ppi.payment_term_id = ppt.payment_term_id
358: AND ppi.payment_schedule_id = p_schedule_id
359: AND (ppt.customer_id IS NULL
360: OR ppt.customer_site_use_id IS NULL

Line 379: pn_payment_items_all ppi

375: SELECT 'Y'
376: FROM dual
377: WHERE EXISTS (SELECT NULL
378: FROM pn_payment_terms_all ppt,
379: pn_payment_items_all ppi
380: WHERE ppi.payment_term_id = ppt.payment_term_id
381: AND ppi.payment_schedule_id = p_schedule_id
382: AND (ppt.vendor_id IS NULL OR
383: ppt.vendor_site_id Is NULL

Line 397: FROM pn_payment_items_all ppi

393: CURSOR check_act_amt (p_schedule_id IN NUMBER) IS
394: SELECT 'Y'
395: FROM dual
396: WHERE EXISTS(SELECT NULL
397: FROM pn_payment_items_all ppi
398: WHERE ppi.payment_schedule_id = p_schedule_id
399: AND ppi.actual_amount IS NULL);
400:
401: -------------------------------------------------------------------------------

Line 447: l_payment_item_id PN_PAYMENT_ITEMS_ALL.payment_item_id%TYPE;

443: l_curr_exists BOOLEAN;
444: l_sched_failed BOOLEAN;
445:
446: /* variables to store the values selected in the main cursor */
447: l_payment_item_id PN_PAYMENT_ITEMS_ALL.payment_item_id%TYPE;
448: l_payment_schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE;
449: l_payment_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
450: l_lease_class_code PN_LEASES_ALL.lease_class_code%TYPE;
451: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;

Line 891: FROM pn_payment_items_all item

887: AND ploc.location_id = pt.location_id
888: AND ploc.location_code >= NVL(p_location_from_code, ploc.location_code)
889: AND ploc.location_code <= NVL(p_location_to_code, ploc.location_code)
890: AND EXISTS(SELECT NULL
891: FROM pn_payment_items_all item
892: WHERE item.payment_schedule_id = pps.payment_schedule_id
893: AND item.due_date BETWEEN NVL(p_trx_from_date,item.due_date)
894: AND NVL(p_trx_to_date,item.due_date))
895: AND NOT EXISTS (SELECT NULL

Line 896: FROM pn_payment_items_all pi

892: WHERE item.payment_schedule_id = pps.payment_schedule_id
893: AND item.due_date BETWEEN NVL(p_trx_from_date,item.due_date)
894: AND NVL(p_trx_to_date,item.due_date))
895: AND NOT EXISTS (SELECT NULL
896: FROM pn_payment_items_all pi
897: WHERE pi.payment_schedule_id = pps.payment_schedule_id
898: AND (pi.TRANSFERRED_TO_AP_FLAG = 'Y' OR
899: pi.TRANSFERRED_TO_AR_FLAG = 'Y')
900: )

Line 921: FROM pn_payment_items_all item

917: AND pl.lease_num <= NVL(p_lease_to_number, pl.lease_num)
918: AND pld.lease_id = pps.lease_id
919: AND pld.responsible_user = NVL(p_responsible_user, pld.responsible_user)
920: AND EXISTS (SELECT NULL
921: FROM pn_payment_items_all item
922: WHERE item.payment_schedule_id = pps.payment_schedule_id
923: AND item.due_date BETWEEN NVL(p_trx_from_date,item.due_date)
924: AND NVL(p_trx_to_date,item.due_date))
925: AND NOT EXISTS (SELECT NULL

Line 926: FROM pn_payment_items_all pi

922: WHERE item.payment_schedule_id = pps.payment_schedule_id
923: AND item.due_date BETWEEN NVL(p_trx_from_date,item.due_date)
924: AND NVL(p_trx_to_date,item.due_date))
925: AND NOT EXISTS (SELECT NULL
926: FROM pn_payment_items_all pi
927: WHERE pi.payment_schedule_id = pps.payment_schedule_id
928: AND (pi.TRANSFERRED_TO_AP_FLAG = 'Y' OR
929: pi.TRANSFERRED_TO_AR_FLAG = 'Y')
930: )