APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_VAR_RENT_DATES_ALL

Line 543: pn_var_rent_dates_all

539: CURSOR calc_freq_c(p_vr_id IN NUMBER) IS
540: SELECT
541: reptg_freq_code AS report_freq_code
542: FROM
543: pn_var_rent_dates_all
544: WHERE
545: var_rent_id = p_vr_id;
546:
547: /* get the number of periods */

Line 585: FROM pn_var_rent_dates_all

581: prd.start_date = var.commencement_date;
582:
583: CURSOR freq_cur(p_vr_id IN NUMBER) IS
584: SELECT var_rent_id
585: FROM pn_var_rent_dates_all
586: WHERE reptg_freq_code = 'YR'
587: AND invg_freq_code = 'YR'
588: AND var_rent_id = p_vr_id;
589:

Line 3390: FROM pn_var_rent_inv_all inv, pn_var_periods_all per, pn_var_rents_all vr, pn_var_rent_dates_all vrd

3386: -- Get the number of inv which should exist for a period
3387: CURSOR num_inv_c(ip_var_rent_inv_id NUMBER
3388: ) IS
3389: SELECT ceil(months_between(per.end_date, per.start_date)/decode(vrd.invg_freq_code,'YR', 12, 'SA', 6, 'QTR', 3, 'MON', 1, 1)) num_inv
3390: FROM pn_var_rent_inv_all inv, pn_var_periods_all per, pn_var_rents_all vr, pn_var_rent_dates_all vrd
3391: WHERE per.period_id = inv.period_id
3392: AND inv.var_rent_inv_id = ip_var_rent_inv_id
3393: AND per.var_rent_id = vr.var_rent_id
3394: AND vrd.var_rent_id = vr.var_rent_id;

Line 5140: pn_var_rent_dates_all

5136: CURSOR calc_freq_c(p_vr_id IN NUMBER) IS
5137: SELECT
5138: reptg_freq_code AS report_freq_code
5139: FROM
5140: pn_var_rent_dates_all
5141: WHERE
5142: var_rent_id = p_vr_id;
5143:
5144: /* get the number of periods */

Line 5705: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates

5701: ,'SA' ,6
5702: ,'YR' ,12
5703: ,NULL) invg_freq_code,
5704: var.proration_rule
5705: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates
5706: WHERE var.var_rent_id = vr_id
5707: AND dates.var_rent_id = var.var_rent_id;
5708:
5709:

Line 5895: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates

5891: ,'QTR',3
5892: ,'SA' ,6
5893: ,'YR' ,12
5894: ,NULL) invg_freq_code
5895: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates
5896: WHERE var.var_rent_id = vr_id
5897: AND dates.var_rent_id = var.var_rent_id;
5898:
5899: CURSOR last_period_cur IS