APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_INDEX_LEASE_PERIODS_ALL

Line 83: FROM pn_index_lease_periods_all pilp

79: INTO v
80: FROM DUAL
81: WHERE EXISTS (
82: SELECT 1
83: FROM pn_index_lease_periods_all pilp
84: ,pn_payment_terms_all ppt
85: WHERE pilp.index_period_id = ppt.index_period_id
86: AND ppt.status = 'APPROVED'
87: AND pilp.index_lease_id = p_index_lease_id

Line 429: FROM pn_index_lease_periods_all

425: v CHAR (1) := 0;
426:
427: CURSOR c IS
428: SELECT *
429: FROM pn_index_lease_periods_all
430: WHERE index_period_id = p_index_period_id;
431: BEGIN
432: FOR c_rec IN c
433: LOOP

Line 465: FROM pn_index_lease_periods_all periods, pn_index_leases_all index_leases,

461: )
462: AS
463: CURSOR c IS
464: SELECT index_leases.commencement_date, lease_det.lease_termination_date
465: FROM pn_index_lease_periods_all periods, pn_index_leases_all index_leases,
466: pn_leases_all leases, pn_lease_details_all lease_det
467: WHERE periods.index_period_id = p_index_period_id
468: AND index_leases.index_lease_id = periods.index_lease_id
469: AND index_leases.lease_id = leases.lease_id

Line 610: FROM pn_index_lease_periods_all

606: ,current_index_line_value
607: ,previous_index_line_id
608: ,previous_index_line_value
609: INTO l_index_lease_periods_rec
610: FROM pn_index_lease_periods_all
611: WHERE index_period_id = p_index_period_id;
612: RETURN l_index_lease_periods_rec;
613: EXCEPTION
614: WHEN OTHERS

Line 702: FROM pn_index_lease_periods_all periods

698: SELECT 1
699: INTO l_period_exists
700: FROM DUAL
701: WHERE EXISTS ( SELECT periods.index_period_id
702: FROM pn_index_lease_periods_all periods
703: WHERE periods.index_lease_id = p_index_lease_id);
704: RETURN l_period_exists;
705: EXCEPTION
706: WHEN OTHERS

Line 1184: FROM pn_index_lease_periods_all periods

1180: SELECT 1
1181: INTO l_hist_line_used
1182: FROM DUAL
1183: WHERE EXISTS ( SELECT periods.previous_index_line_id
1184: FROM pn_index_lease_periods_all periods
1185: ,pn_index_history_lines lines
1186: WHERE periods.previous_index_line_id = lines.index_line_id
1187: AND lines.index_line_id = p_index_line_id);
1188: RETURN l_hist_line_used;

Line 1202: FROM pn_index_lease_periods_all periods

1198: SELECT 2
1199: INTO l_hist_line_used
1200: FROM DUAL
1201: WHERE EXISTS ( SELECT periods.current_index_line_id
1202: FROM pn_index_lease_periods_all periods
1203: ,pn_index_history_lines lines
1204: WHERE periods.current_index_line_id = lines.index_line_id
1205: AND lines.index_line_id = p_index_line_id);
1206: RETURN l_hist_line_used;

Line 1236: ,pn_index_lease_periods_all periods

1232: FROM DUAL
1233: WHERE EXISTS ( SELECT terms.payment_term_id
1234: FROM pn_payment_terms_all terms
1235: ,pn_index_leases_all lease
1236: ,pn_index_lease_periods_all periods
1237: WHERE terms.index_period_id = periods.index_period_id
1238: AND periods.index_lease_id = lease.index_lease_id
1239: AND lease.index_lease_id = p_index_lease_id);
1240: RETURN l_calc_exists;

Line 1265: FROM pn_index_lease_periods_all

1261: SELECT 1
1262: INTO l_basis_exists
1263: FROM DUAL
1264: WHERE EXISTS ( SELECT current_basis
1265: FROM pn_index_lease_periods_all
1266: WHERE index_lease_id = p_index_lease_id
1267: AND current_basis is null);
1268: RETURN l_basis_exists;
1269: EXCEPTION

Line 1293: FROM pn_index_lease_periods_all pilp,

1289: BEGIN
1290: BEGIN
1291: SELECT max(SCHEDULE_DATE)
1292: INTO l_max_sch_date
1293: FROM pn_index_lease_periods_all pilp,
1294: pn_payment_terms_all ppt,
1295: pn_payment_items_all ppi,
1296: pn_payment_schedules_all pps
1297: WHERE pilp.index_period_id=ppt.index_period_id

Line 1407: PN_INDEX_LEASE_PERIODS_ALL pilp

1403: CURSOR C_UPD_TERMS IS
1404: SELECT ppt.payment_term_id,
1405: NVL(ppt.status, 'X')
1406: FROM PN_PAYMENT_TERMS_ALL ppt,
1407: PN_INDEX_LEASE_PERIODS_ALL pilp
1408: WHERE ppt.status = 'DRAFT'
1409: AND ppt.index_period_id = pilp.index_period_id
1410: AND pilp.index_lease_id = p_index_lease_id
1411: UNION ALL

Line 1415: PN_INDEX_LEASE_PERIODS_ALL pilp,

1411: UNION ALL
1412: SELECT ppt.payment_term_id,
1413: NVL(ppt.status, 'X')
1414: FROM PN_PAYMENT_TERMS_ALL ppt,
1415: PN_INDEX_LEASE_PERIODS_ALL pilp,
1416: PN_LEASES_ALL pl
1417: WHERE ppt.status = 'APPROVED'
1418: AND ppt.lease_id = pl.lease_id
1419: AND ppt.index_period_id = pilp.index_period_id