APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_LEASES

Line 5125: v_lease_class_code pn_leases.lease_class_code%TYPE;

5121: v_attribute14 pn_term_templates.attribute14%TYPE;
5122: v_attribute15 pn_term_templates.attribute15%TYPE;
5123: v_lease_termination_date pn_lease_details.lease_termination_date%TYPE;
5124: v_lease_change_id pn_lease_details.lease_change_id%TYPE;
5125: v_lease_class_code pn_leases.lease_class_code%TYPE;
5126: v_distribution_id pn_distributions.distribution_id%TYPE;
5127: v_rowid VARCHAR2 (100);
5128: v_payment_term_id pn_payment_terms.payment_term_id%TYPE;
5129: v_freq_divisor NUMBER;

Line 5174: FROM pn_leases_all

5170: WHERE index_period_id = p_index_period_id);
5171:
5172: CURSOR org_id_cur IS
5173: SELECT org_id
5174: FROM pn_leases_all
5175: WHERE lease_id = p_lease_id;
5176:
5177:
5178: CURSOR get_vr_nbp_flag IS

Line 5476: FROM pn_leases_all pl, pn_lease_details_all pld

5472: INTO v_lease_class_code
5473: ,v_expense_account_id
5474: ,v_lease_termination_date
5475: ,v_lease_change_id
5476: FROM pn_leases_all pl, pn_lease_details_all pld
5477: WHERE pl.lease_id = pld.lease_id
5478: AND pld.lease_id = p_lease_id;
5479:
5480: EXCEPTION

Line 6012: pn_leases_all pl

6008: ,pil.proration_period_start_date
6009: ,pil.assessment_interval
6010: FROM pn_index_leases_all pil,
6011: pn_index_lease_periods_all pilp,
6012: pn_leases_all pl
6013: WHERE pil.index_lease_id = pilp.index_lease_id
6014: AND pil.lease_id = pl.lease_id
6015: AND pilp.index_period_id = p_index_lease_period_id;
6016:

Line 6023: FROM pn_leases_all lease, pn_lease_details_all ldet

6019: CURSOR get_lease_details(p_lease_id NUMBER) IS
6020: SELECT lease_commencement_date,
6021: lease_termination_date,
6022: lease_extension_end_date
6023: FROM pn_leases_all lease, pn_lease_details_all ldet
6024: WHERE lease.lease_id = ldet.lease_id
6025: AND lease.lease_id = p_lease_id;
6026:
6027: CURSOR get_extendable_terms(p_index_period_id NUMBER,l_term_date DATE) IS

Line 6758: FROM pn_leases_all pl, pn_index_leases pil, pn_index_lease_periods_all pilp

6754: ,pilp.assessment_date
6755: ,pil.index_lease_number
6756: ,pil.term_template_id
6757: ,pil.org_id
6758: FROM pn_leases_all pl, pn_index_leases pil, pn_index_lease_periods_all pilp
6759: WHERE pl.lease_id = pil.lease_id
6760: AND pil.index_lease_id = pilp.index_lease_id
6761: AND (pil.index_lease_number >= nvl(p_index_rent_number_lower,pil.index_lease_number))
6762: AND (pil.index_lease_number <= nvl(p_index_rent_number_upper,pil.index_lease_number))

Line 7262: FROM pn_leases_all pl

7258: ,ppt.index_term_indicator
7259: ,ppt.status
7260: ,DECODE (ppt.normalize, 'Y', 'NORMALIZE') "NORMALIZE"
7261: ,ppt.schedule_day
7262: FROM pn_leases_all pl
7263: ,pn_index_leases pil
7264: ,pn_index_lease_periods_all pilp
7265: ,pn_payment_terms_all ppt
7266: WHERE pl.lease_id = pil.lease_id