APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_LEASES

Line 5123: v_lease_class_code pn_leases.lease_class_code%TYPE;

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

Line 5172: FROM pn_leases_all

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

Line 5474: FROM pn_leases_all pl, pn_lease_details_all pld

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

Line 6010: pn_leases_all pl

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

Line 6021: FROM pn_leases_all lease, pn_lease_details_all ldet

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

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

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

Line 7260: FROM pn_leases_all pl

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