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_MASS_APPR_PKG dependencies on PN_LEASES

Line 280: pn_leases pl,

276: pl.lease_id s_lease_id,
277: pl.lease_num s_lease_number,
278: pl.name s_lease_name
279: FROM pn_payment_schedules_all pps,
280: pn_leases pl,
281: pn_lease_details_all pld,
282: pn_tenancies_all pt,
283: pn_locations_all ploc
284: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)

Line 319: pn_leases pl,

315: pl.lease_id s_lease_id,
316: pl.lease_num s_lease_number,
317: pl.name s_lease_name
318: FROM pn_payment_schedules_all pps,
319: pn_leases pl,
320: pn_lease_details_all pld
321: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)
322: AND NVL(p_schedule_to_date, pps.schedule_date)
323: AND pps.payment_status_lookup_code = 'DRAFT'

Line 450: l_lease_class_code PN_LEASES_ALL.lease_class_code%TYPE;

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;
452: l_lease_id PN_LEASES_ALL.lease_id%TYPE;
453: l_lease_number PN_LEASES_ALL.lease_num%TYPE;
454: l_lease_name PN_LEASES_ALL.name%TYPE;

Line 452: l_lease_id PN_LEASES_ALL.lease_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;
452: l_lease_id PN_LEASES_ALL.lease_id%TYPE;
453: l_lease_number PN_LEASES_ALL.lease_num%TYPE;
454: l_lease_name PN_LEASES_ALL.name%TYPE;
455:
456: /* variables to handle updation and related processes */

Line 453: l_lease_number PN_LEASES_ALL.lease_num%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;
452: l_lease_id PN_LEASES_ALL.lease_id%TYPE;
453: l_lease_number PN_LEASES_ALL.lease_num%TYPE;
454: l_lease_name PN_LEASES_ALL.name%TYPE;
455:
456: /* variables to handle updation and related processes */
457: l_application_id NUMBER;

Line 454: l_lease_name PN_LEASES_ALL.name%TYPE;

450: l_lease_class_code PN_LEASES_ALL.lease_class_code%TYPE;
451: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
452: l_lease_id PN_LEASES_ALL.lease_id%TYPE;
453: l_lease_number PN_LEASES_ALL.lease_num%TYPE;
454: l_lease_name PN_LEASES_ALL.name%TYPE;
455:
456: /* variables to handle updation and related processes */
457: l_application_id NUMBER;
458: l_applicable_period GL_PERIOD_STATUSES.period_name%TYPE;

Line 873: pn_leases pl,

869: pps.payment_schedule_id s_payment_schedule_id,
870: pps.schedule_date s_schedule_date,
871: pl.lease_id s_lease_id
872: FROM pn_payment_schedules_all pps,
873: pn_leases pl,
874: pn_lease_details_all pld,
875: pn_tenancies_all pt,
876: pn_locations_all ploc
877: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)

Line 909: pn_leases pl,

905: pps.payment_schedule_id s_payment_schedule_id,
906: pps.schedule_date s_schedule_date,
907: pl.lease_id s_lease_id
908: FROM pn_payment_schedules_all pps,
909: pn_leases pl,
910: pn_lease_details_all pld
911: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)
912: AND NVL(p_schedule_to_date, pps.schedule_date)
913: AND pps.payment_status_lookup_code = 'APPROVED'

Line 939: l_lease_id PN_LEASES_ALL.lease_id%TYPE;

935:
936: /* variables */
937: l_payment_schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE;
938: l_payment_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
939: l_lease_id PN_LEASES_ALL.lease_id%TYPE;
940:
941: BEGIN
942:
943: PNP_DEBUG_PKG.debug ('PN_MASS_APPR_PKG.unapprove (+)');