DBA Data[Home] [Help]

APPS.PN_MASS_APPR_PKG dependencies on PN_LEASES_ALL

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 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 (+)');