APPS.PN_MASS_APPR_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 279: FROM pn_payment_schedules_all pps,

275: pl.lease_class_code s_lease_class_code,
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

Line 318: FROM pn_payment_schedules_all pps,

314: pl.lease_class_code s_lease_class_code,
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)

Line 448: l_payment_schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE;

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;
452: l_lease_id PN_LEASES_ALL.lease_id%TYPE;

Line 449: l_payment_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;

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

Line 872: FROM pn_payment_schedules_all pps,

868: SELECT DISTINCT
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

Line 908: FROM pn_payment_schedules_all pps,

904: SELECT DISTINCT
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)

Line 937: l_payment_schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE;

933: /* counters */
934: l_sch_unapp NUMBER;
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

Line 938: l_payment_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;

934: l_sch_unapp NUMBER;
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: