APPS.PN_VARIABLE_TERM_PKG dependencies on PN_LEASES

Line 54: FROM pn_leases pl,

50: per.period_id,
51: per.period_num,
52: pl.lease_class_code,
53: pl.org_id
54: FROM pn_leases pl,
55: pn_lease_details_all pld,
56: pn_var_rents_all pvr,
57: pn_locations_all ploc,
58: pn_var_periods_all per

Line 88: pn_leases pl,

84: per.period_num,
85: pl.lease_class_code,
86: pl.org_id
87: FROM pn_var_rents_all pvr,
88: pn_leases pl,
89: pn_lease_details_all pld,
90: pn_var_periods_all per
91: WHERE pl.lease_id = pvr.lease_id
92: AND pld.lease_id = pvr.lease_id

Line 190: l_org_id pn_leases.org_id%type;

186: l_var_rent_id pn_var_rents.var_rent_id%type;
187: l_pre_var_rent_id pn_var_rents.var_rent_id%type;
188: l_context VARCHAR2(2000);
189: l_errmsg VARCHAR2(2000);
190: l_org_id pn_leases.org_id%type;
191: l_term_temp_id pn_payment_terms.term_template_id%TYPE;
192: l_lease_cls_code pn_leases.lease_class_code%TYPE;
193: l_err_flag VARCHAR2(1);
194: l_inv_sch_date DATE;

Line 192: l_lease_cls_code pn_leases.lease_class_code%TYPE;

188: l_context VARCHAR2(2000);
189: l_errmsg VARCHAR2(2000);
190: l_org_id pn_leases.org_id%type;
191: l_term_temp_id pn_payment_terms.term_template_id%TYPE;
192: l_lease_cls_code pn_leases.lease_class_code%TYPE;
193: l_err_flag VARCHAR2(1);
194: l_inv_sch_date DATE;
195: l_inv_start_date DATE;
196: term_count NUMBER;

Line 659: -- pn_term_templates, pn_leases with _ALL table.

655: -- Bug # 3841542
656: -- 21-APR-05 ftanudja o Added area_type_code, area defaulting. #4324777
657: -- 15-JUL-05 ftanudja o R12 changes: add logic for tax_clsfctn_code. #4495054
658: -- 21-JUN-05 hareesha o Bug 4284035 - Replaced pn_var_rents, pn_distributions,
659: -- pn_term_templates, pn_leases with _ALL table.
660: -- 23-NOV-05 pikhar o Passed org_id in pn_mo_cache_utils.get_profile_value
661: -- 13-DEC-05 rdonthul o Changed the l_payment_term_date for bug 5700403
662: -- 15-MAR-07 pikhar o Bug 5930387. Added include_in_var_rent
663: -------------------------------------------------------------------------------

Line 677: l_lease_class_code pn_leases.lease_class_code%TYPE;

673: ,p_var_rent_type IN VARCHAR2
674: ,p_org_id IN NUMBER
675: ) IS
676:
677: l_lease_class_code pn_leases.lease_class_code%TYPE;
678: l_distribution_id pn_distributions.distribution_id%TYPE;
679: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
680: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
681: l_rowid ROWID;

Line 744: FROM pn_leases_all pl,

740: pl.org_id
741: INTO l_lease_class_code,
742: l_lease_change_id,
743: l_org_id
744: FROM pn_leases_all pl,
745: pn_lease_details_all pld
746: WHERE pl.lease_id = pld.lease_id
747: AND pld.lease_id = p_lease_id;
748: