APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_PERIODS_ALL

Line 85: ,pn_var_periods_all prd

81:
82: CURSOR proration_rule_prd_c IS
83: SELECT proration_rule
84: FROM pn_var_rents_all vr
85: ,pn_var_periods_all prd
86: WHERE vr.var_rent_id = prd.var_rent_id
87: AND prd.period_id = p_period_id;
88:
89: l_proration_rule VARCHAR2(30);

Line 686: pn_var_periods_all prd

682: SELECT
683: prd.period_id
684: ,prd.partial_period
685: FROM
686: pn_var_periods_all prd
687: WHERE
688: prd.var_rent_id = p_var_rent_id AND
689: prd.end_date = p_term_date;
690:

Line 873: pn_var_periods_all prd

869: SELECT
870: prd.period_id
871: ,prd.partial_period
872: FROM
873: pn_var_periods_all prd
874: WHERE
875: prd.var_rent_id = p_var_rent_id AND
876: prd.start_date = p_comm_date;
877:

Line 936: pn_var_periods_all prd

932: var_rent_id = p_var_rent_id AND
933: period_id = (SELECT
934: prd.period_id
935: FROM
936: pn_var_periods_all prd
937: WHERE
938: prd.var_rent_id = p_var_rent_id AND
939: prd.start_date = l_vr_commencement_date AND
940: prd.partial_period = 'Y');

Line 1050: pn_var_periods_all

1046: ,start_date
1047: ,end_date
1048: ,partial_period
1049: FROM
1050: pn_var_periods_all
1051: WHERE
1052: var_rent_id = p_vr_id
1053: ORDER BY
1054: start_date;

Line 1086: ,pn_var_periods_all prd

1082: SELECT
1083: SUM(grp.proration_factor) proration_factor_sum
1084: FROM
1085: pn_var_grp_dates_all grp
1086: ,pn_var_periods_all prd
1087: WHERE
1088: prd.period_id = p_prd_id AND
1089: grp.period_id = prd.period_id AND
1090: grp.grp_end_date <= prd.end_date

Line 1510: pn_var_periods_all

1506: ,start_date
1507: ,end_date
1508: ,partial_period
1509: FROM
1510: pn_var_periods_all
1511: WHERE
1512: var_rent_id = p_vr_id
1513: ORDER BY
1514: start_date;

Line 1809: pn_var_periods_all

1805: CURSOR periods_c(p_vr_id IN NUMBER) IS
1806: SELECT
1807: period_id
1808: FROM
1809: pn_var_periods_all
1810: WHERE
1811: var_rent_id = p_vr_id
1812: ORDER BY
1813: start_date;

Line 1859: FROM pn_var_periods_all

1855:
1856: -- Get first partial period id
1857: CURSOR check_fst_partial_prd(p_period_id IN NUMBER) IS
1858: SELECT period_id
1859: FROM pn_var_periods_all
1860: WHERE period_id = p_period_id
1861: AND period_num=1
1862: AND partial_period='Y';
1863:

Line 1870: pn_var_periods_all prd,

1866: SELECT
1867: prd.period_id
1868: ,prd.partial_period
1869: FROM
1870: pn_var_periods_all prd,
1871: pn_var_rents_all var
1872: WHERE
1873: prd.period_id = p_period_id AND
1874: prd.var_rent_id = var.var_rent_id AND

Line 2120: pn_var_periods_all

2116: MINUS
2117: SELECT
2118: period_id
2119: FROM
2120: pn_var_periods_all
2121: WHERE
2122: var_rent_id = p_vr_id AND
2123: status IS NULL;
2124:

Line 2133: pn_var_periods_all prd

2129: ,prd.period_id
2130: ,prd.start_date
2131: ,prd.end_date
2132: FROM
2133: pn_var_periods_all prd
2134: WHERE
2135: prd.var_rent_id = p_vr_id AND
2136: prd.status IS NULL
2137: ORDER BY

Line 2200: ,pn_var_periods_all prd

2196: ,grp.invoice_date
2197: ,grp.proration_factor
2198: FROM
2199: pn_var_grp_dates_all grp
2200: ,pn_var_periods_all prd
2201: WHERE
2202: prd.period_id = p_prd_id AND
2203: grp.period_id = prd.period_id AND
2204: grp.grp_end_date <= prd.end_date

Line 3197: pn_var_periods_all prd

3193: SELECT
3194: prd.period_id
3195: ,prd.partial_period
3196: FROM
3197: pn_var_periods_all prd
3198: WHERE
3199: prd.var_rent_id = p_var_rent_id AND
3200: prd.end_date = p_term_date;
3201:

Line 3320: pn_var_periods_all prd

3316: SELECT
3317: prd.period_id
3318: ,prd.partial_period
3319: FROM
3320: pn_var_periods_all prd
3321: WHERE
3322: prd.var_rent_id = p_var_rent_id AND
3323: prd.start_date = p_comm_date;
3324:

Line 3466: pn_var_periods_all

3462: ,start_date
3463: ,end_date
3464: ,partial_period
3465: FROM
3466: pn_var_periods_all
3467: WHERE
3468: var_rent_id = p_vr_id
3469: ORDER BY
3470: start_date;

Line 4997: pn_var_periods_all

4993: ,start_date
4994: ,end_date
4995: ,partial_period
4996: FROM
4997: pn_var_periods_all
4998: WHERE
4999: var_rent_id = p_vr_id
5000: ORDER BY
5001: start_date;