APPS.PN_GENERATE_PMT_SCHED dependencies on DUAL

Line 150: from dual;

146:
147: -- get the first of the month
148: select trunc (i.start_date, 'MM')
149: into l_paymentScheduleDate
150: from dual;
151:
152: select max (payment_schedule_id)
153: into l_paymentScheduleId
154: from pn_payment_schedules_all /*sdm14jul*/

Line 163: FROM dual;

159: IF (l_paymentScheduleId IS NULL) THEN
160:
161: SELECT pn_payment_schedules_s.nextval
162: INTO l_paymentScheduleId
163: FROM dual;
164:
165: /*sdm14jul*/
166: SELECT org_id INTO l_org_id
167: FROM pn_leases_all

Line 256: from dual;

252: i.actual_amount,
253: 1,
254: decode (l_paymentStatusLookupCode, 'APPROVED', 'Y',NULL),
255: l_org_id /*sdm14jul*/
256: from dual;
257:
258: END LOOP;
259: END CREATE_OT_PAYMENT_ITEMS;
260:

Line 358: FROM dual;

354: IF ps_id is null THEN
355:
356: SELECT pn_payment_schedules_s.nextval
357: INTO ps_id
358: FROM dual;
359:
360: /*sdm14jul*/
361: SELECT org_id INTO l_org_id
362: FROM pn_leases_all

Line 460: FROM dual;

456: IF ps_id is null THEN
457:
458: SELECT pn_payment_schedules_s.nextval
459: INTO ps_id
460: FROM dual;
461:
462: INSERT INTO pn_payment_schedules_all /*sdm14jul*/
463: ( payment_schedule_id,
464: last_update_date,

Line 739: FROM dual;

735: IF ps_id is null THEN
736:
737: SELECT pn_payment_schedules_s.nextval
738: INTO ps_id
739: FROM dual;
740:
741: IF (rent_sched_date < min_sched_date) THEN
742:
743: INSERT INTO pn_payment_schedules_all /*sdm14jul*/