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 1512: pn_var_periods_all

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

Line 1895: pn_var_periods_all

1891: CURSOR periods_c(p_vr_id IN NUMBER) IS
1892: SELECT
1893: period_id
1894: FROM
1895: pn_var_periods_all
1896: WHERE
1897: var_rent_id = p_vr_id
1898: ORDER BY
1899: start_date;

Line 1947: FROM pn_var_periods_all

1943:
1944: -- Get first partial period id
1945: CURSOR check_fst_partial_prd(p_period_id IN NUMBER) IS
1946: SELECT period_id
1947: FROM pn_var_periods_all
1948: WHERE period_id = p_period_id
1949: AND period_num=1
1950: AND partial_period='Y';
1951:

Line 1958: pn_var_periods_all prd,

1954: SELECT
1955: prd.period_id
1956: ,prd.partial_period
1957: FROM
1958: pn_var_periods_all prd,
1959: pn_var_rents_all var
1960: WHERE
1961: prd.period_id = p_period_id AND
1962: prd.var_rent_id = var.var_rent_id AND

Line 2209: pn_var_periods_all

2205: MINUS
2206: SELECT
2207: period_id
2208: FROM
2209: pn_var_periods_all
2210: WHERE
2211: var_rent_id = p_vr_id AND
2212: status IS NULL;
2213:

Line 2222: pn_var_periods_all prd

2218: ,prd.period_id
2219: ,prd.start_date
2220: ,prd.end_date
2221: FROM
2222: pn_var_periods_all prd
2223: WHERE
2224: prd.var_rent_id = p_vr_id AND
2225: prd.status IS NULL
2226: ORDER BY

Line 2289: ,pn_var_periods_all prd

2285: ,grp.invoice_date
2286: ,grp.proration_factor
2287: FROM
2288: pn_var_grp_dates_all grp
2289: ,pn_var_periods_all prd
2290: WHERE
2291: prd.period_id = p_prd_id AND
2292: grp.period_id = prd.period_id AND
2293: grp.grp_end_date <= prd.end_date

Line 3287: pn_var_periods_all prd

3283: SELECT
3284: prd.period_id
3285: ,prd.partial_period
3286: FROM
3287: pn_var_periods_all prd
3288: WHERE
3289: prd.var_rent_id = p_var_rent_id AND
3290: prd.end_date = p_term_date;
3291:

Line 3410: pn_var_periods_all prd

3406: SELECT
3407: prd.period_id
3408: ,prd.partial_period
3409: FROM
3410: pn_var_periods_all prd
3411: WHERE
3412: prd.var_rent_id = p_var_rent_id AND
3413: prd.start_date = p_comm_date;
3414:

Line 3556: pn_var_periods_all

3552: ,start_date
3553: ,end_date
3554: ,partial_period
3555: FROM
3556: pn_var_periods_all
3557: WHERE
3558: var_rent_id = p_vr_id
3559: ORDER BY
3560: start_date;

Line 5087: pn_var_periods_all

5083: ,start_date
5084: ,end_date
5085: ,partial_period
5086: FROM
5087: pn_var_periods_all
5088: WHERE
5089: var_rent_id = p_vr_id
5090: ORDER BY
5091: start_date;