APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_RENTS_ALL

Line 59: pn_var_rents_all pvr,

55: pl.lease_class_code,
56: pl.org_id
57: FROM pn_leases pl,
58: pn_lease_details_all pld,
59: pn_var_rents_all pvr,
60: pn_locations_all ploc,
61: pn_var_periods_all per
62: WHERE pl.lease_id = pvr.lease_id
63: AND pld.lease_id = pvr.lease_id

Line 90: FROM pn_var_rents_all pvr,

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

Line 706: FROM pn_var_rents_all

702: IS
703: SELECT *
704: FROM pn_distributions_all
705: WHERE term_template_id = (SELECT term_template_id
706: FROM pn_var_rents_all
707: WHERE var_rent_id = p_var_rent_id);
708:
709: CURSOR csr_template (p_var_rent_id IN NUMBER)
710: IS

Line 714: FROM pn_var_rents_all

710: IS
711: SELECT *
712: FROM pn_term_templates_all
713: WHERE term_template_id = (SELECT term_template_id
714: FROM pn_var_rents_all
715: WHERE var_rent_id = p_var_rent_id);
716:
717: CURSOR currency_code_cur IS
718: SELECT currency_code

Line 719: FROM pn_var_rents_all

715: WHERE var_rent_id = p_var_rent_id);
716:
717: CURSOR currency_code_cur IS
718: SELECT currency_code
719: FROM pn_var_rents_all
720: WHERE var_rent_id = p_var_rent_id;
721:
722: rec_template pn_term_templates_all%ROWTYPE;
723: term_count NUMBER := 0;

Line 724: l_currency_code pn_var_rents_all.currency_code%TYPE;

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

Line 1230: FROM pn_var_rents_all

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