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 5051: pn_var_rent_dates_all

5047: CURSOR calc_freq_c(p_vr_id IN NUMBER) IS
5048: SELECT
5049: reptg_freq_code AS report_freq_code
5050: FROM
5051: pn_var_rent_dates_all
5052: WHERE
5053: var_rent_id = p_vr_id;
5054:
5055: /* get the number of periods */

Line 5616: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates

5612: ,'SA' ,6
5613: ,'YR' ,12
5614: ,NULL) invg_freq_code,
5615: var.proration_rule
5616: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates
5617: WHERE var.var_rent_id = vr_id
5618: AND dates.var_rent_id = var.var_rent_id;
5619:
5620:

Line 5806: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates

5802: ,'QTR',3
5803: ,'SA' ,6
5804: ,'YR' ,12
5805: ,NULL) invg_freq_code
5806: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates
5807: WHERE var.var_rent_id = vr_id
5808: AND dates.var_rent_id = var.var_rent_id;
5809:
5810: CURSOR last_period_cur IS