APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_RENTS_ALL

Line 56: pn_var_rents_all pvr,

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
59: WHERE pl.lease_id = pvr.lease_id
60: AND pld.lease_id = pvr.lease_id

Line 87: FROM pn_var_rents_all pvr,

83: per.period_id,
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

Line 702: FROM pn_var_rents_all

698: IS
699: SELECT *
700: FROM pn_distributions_all
701: WHERE term_template_id = (SELECT term_template_id
702: FROM pn_var_rents_all
703: WHERE var_rent_id = p_var_rent_id);
704:
705: CURSOR csr_template (p_var_rent_id IN NUMBER)
706: IS

Line 710: FROM pn_var_rents_all

706: IS
707: SELECT *
708: FROM pn_term_templates_all
709: WHERE term_template_id = (SELECT term_template_id
710: FROM pn_var_rents_all
711: WHERE var_rent_id = p_var_rent_id);
712:
713: CURSOR currency_code_cur IS
714: SELECT currency_code

Line 715: FROM pn_var_rents_all

711: WHERE var_rent_id = p_var_rent_id);
712:
713: CURSOR currency_code_cur IS
714: SELECT currency_code
715: FROM pn_var_rents_all
716: WHERE var_rent_id = p_var_rent_id;
717:
718: rec_template pn_term_templates_all%ROWTYPE;
719: term_count NUMBER := 0;

Line 720: l_currency_code pn_var_rents_all.currency_code%TYPE;

716: WHERE var_rent_id = p_var_rent_id;
717:
718: rec_template pn_term_templates_all%ROWTYPE;
719: term_count NUMBER := 0;
720: l_currency_code pn_var_rents_all.currency_code%TYPE;
721: --l_global_rec pn_mo_cache_utils.GlobalsRecord;
722:
723: -- Get the details of
724: /*CURSOR invoice_date_c IS

Line 1226: FROM pn_var_rents_all

1222:
1223: -- Get the VR details
1224: CURSOR vrent_cur(p_vr_id IN NUMBER) IS
1225: SELECT proration_rule, commencement_date, termination_date
1226: FROM pn_var_rents_all
1227: WHERE var_rent_id = p_vr_id;
1228:
1229: -- Get partial period information
1230: CURSOR partial_prd(p_vr_id IN NUMBER) IS