APPS.PN_VAR_TRUEUP_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 52: pn_var_grp_dates_all g,

48: ,p_prd_id IN NUMBER) IS
49: SELECT
50: invoice_date
51: FROM
52: pn_var_grp_dates_all g,
53: pn_var_periods_all p
54: WHERE
55: g.var_rent_id = p_vr_id AND
56: g.period_id = p_prd_id AND

Line 64: pn_var_grp_dates_all g,

60: SELECT
61: g.invoice_date
62: FROM
63: pn_var_trx_headers_all t,
64: pn_var_grp_dates_all g,
65: pn_var_periods_all p
66: WHERE
67: t.grp_date_id = g.grp_date_id AND
68: t.var_rent_id = p_vr_id AND

Line 237: pn_var_grp_dates_all

233: line_item_id = trueup_rec.line_item_id AND
234: grp_date_id = (SELECT
235: grp_date_id
236: FROM
237: pn_var_grp_dates_all
238: WHERE
239: period_id = p_period_id AND
240: grp_end_date = trueup_rec.trueup_date)
241: RETURNING

Line 1204: FROM pn_var_grp_dates_all

1200:
1201: CURSOR csr_last_inv(p_var_rent_id NUMBER)
1202: IS
1203: SELECT MAX(invoice_date) inv_date
1204: FROM pn_var_grp_dates_all
1205: WHERE var_rent_id = p_var_rent_id
1206: AND period_id = (SELECT max(period_id)
1207: FROM pn_var_periods_all
1208: WHERE var_rent_id = p_var_rent_id

Line 1364: FROM pn_var_grp_dates_all

1360:
1361: CURSOR csr_last_inv(p_var_rent_id NUMBER)
1362: IS
1363: SELECT MAX(invoice_date) inv_date
1364: FROM pn_var_grp_dates_all
1365: WHERE var_rent_id = p_var_rent_id
1366: AND period_id = (SELECT max(period_id)
1367: FROM pn_var_periods_all
1368: WHERE var_rent_id = p_var_rent_id

Line 1518: FROM pn_var_grp_dates_all

1514: CURSOR invoice_dates_c(ip_var_rent_id NUMBER,
1515: ip_invoice_date DATE
1516: ) IS
1517: SELECT inv_start_date, inv_end_date
1518: FROM pn_var_grp_dates_all
1519: WHERE var_rent_id = ip_var_rent_id
1520: AND invoice_date = ip_invoice_date;
1521: -- Get the details of actual start and end date for FY/LY/FLY
1522: CURSOR invoice_dates_fyly_c(ip_var_rent_inv_id NUMBER

Line 1561: FROM pn_var_grp_dates_all

1557: ip_period_id NUMBER
1558: ) IS
1559: SELECT MIN(inv_start_date)inv_start_date,
1560: MAX(inv_end_date) inv_end_date
1561: FROM pn_var_grp_dates_all
1562: WHERE var_rent_id = ip_var_rent_id
1563: AND period_id = ip_period_id;
1564:
1565: -- Get the details of negative_rent

Line 1919: FROM pn_var_grp_dates_all

1915: CURSOR invoice_dates_c(ip_var_rent_id NUMBER,
1916: ip_invoice_date DATE
1917: ) IS
1918: SELECT inv_start_date, inv_end_date
1919: FROM pn_var_grp_dates_all
1920: WHERE var_rent_id = ip_var_rent_id
1921: AND invoice_date = ip_invoice_date;
1922: --Get the details of inv_start, end_date for TU
1923: CURSOR invoice_dates_tu_c(ip_var_rent_id NUMBER,

Line 1928: FROM pn_var_grp_dates_all

1924: ip_period_id NUMBER
1925: ) IS
1926: SELECT MIN(inv_start_date)inv_start_date,
1927: MAX(inv_end_date) inv_end_date
1928: FROM pn_var_grp_dates_all
1929: WHERE var_rent_id = ip_var_rent_id
1930: AND period_id = ip_period_id;
1931:
1932: -- Get the details of actual start and end date for FY/LY/FLY

Line 2175: FROM pn_var_grp_dates_all

2171:
2172: --Get the last and first invoice dates for this period.
2173: CURSOR csr_min_gd(ip_var_rent_id NUMBER, ip_period_id NUMBER) IS
2174: SELECT MIN(grp_start_date) min_date
2175: FROM pn_var_grp_dates_all
2176: WHERE period_id = ip_period_id
2177: AND var_rent_id = ip_var_rent_id;
2178:
2179: CURSOR csr_max_gd(ip_var_rent_id NUMBER, ip_period_id NUMBER) IS

Line 2181: FROM pn_var_grp_dates_all

2177: AND var_rent_id = ip_var_rent_id;
2178:
2179: CURSOR csr_max_gd(ip_var_rent_id NUMBER, ip_period_id NUMBER) IS
2180: SELECT MAX(grp_end_date) max_date
2181: FROM pn_var_grp_dates_all
2182: WHERE period_id = ip_period_id
2183: AND var_rent_id = ip_var_rent_id;
2184:
2185: CURSOR get_first_tu_c(ip_period_id NUMBER