APPS.PN_VAR_TRUEUP_PKG dependencies on PN_VAR_TRX_HEADERS_ALL

Line 40: pn_var_trx_headers_all

36: SELECT 1 FROM DUAL WHERE EXISTS
37: (SELECT
38: trx_header_id
39: FROM
40: pn_var_trx_headers_all
41: WHERE
42: var_rent_id = p_vr_id AND
43: period_id = p_prd_id AND
44: reporting_group_sales IS NOT NULL);

Line 63: pn_var_trx_headers_all t,

59: MINUS
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

Line 135: pn_var_trx_headers_all

131: ,NVL(SUM(trueup_rent_due),0) AS trueup_rent
132: ,MAX(calc_prd_end_date) AS trueup_date
133: ,line_item_id
134: FROM
135: pn_var_trx_headers_all
136: WHERE
137: var_rent_id = p_vr_id AND
138: period_id = p_prd_id
139: GROUP BY

Line 152: pn_var_trx_headers_all trx

148: ,line_item_id
149: FROM
150: pn_var_periods_all prd,
151: pn_var_rents_all var,
152: pn_var_trx_headers_all trx
153: WHERE
154: prd.var_rent_id = p_vr_id AND
155: prd.var_rent_id = var.var_rent_id AND
156: prd.start_date = var.commencement_date AND

Line 2370: pn_var_trx_headers_all

2366: ,p_prd_id IN NUMBER) IS
2367: SELECT
2368: line_item_id
2369: FROM
2370: pn_var_trx_headers_all
2371: WHERE
2372: var_rent_id = p_vr_id AND
2373: period_id = p_prd_id
2374: GROUP BY

Line 2386: pn_var_trx_headers_all

2382: MIN(calc_prd_start_date) AS trueup_start_date
2383: ,MAX(calc_prd_end_date) AS trueup_end_date
2384: ,reset_group_id
2385: FROM
2386: pn_var_trx_headers_all
2387: WHERE
2388: var_rent_id = p_vr_id AND
2389: period_id = p_prd_id AND
2390: line_item_id = p_line_id

Line 2404: pn_var_trx_headers_all

2400: ,p_end_dt IN DATE) IS
2401: SELECT
2402: ytd_sales
2403: FROM
2404: pn_var_trx_headers_all
2405: WHERE
2406: var_rent_id = p_vr_id AND
2407: period_id = p_prd_id AND
2408: line_item_id = p_line_id AND

Line 2432: pn_var_trx_headers_all

2428: WHERE
2429: trx_header_id IN (SELECT
2430: trx_header_id
2431: FROM
2432: pn_var_trx_headers_all
2433: WHERE
2434: var_rent_id = p_vr_id AND
2435: period_id = p_prd_id AND
2436: line_item_id = p_line_id AND

Line 2547: pn_var_trx_headers_all

2543: ,p_prd_id => prd_rec.period_id) LOOP
2544:
2545: /* re init the TRUEUP amount */
2546: UPDATE
2547: pn_var_trx_headers_all
2548: SET
2549: trueup_rent_due = 0
2550: WHERE
2551: var_rent_id = p_var_rent_id AND

Line 2724: pn_var_trx_headers_all

2720:
2721: l_tot_trueup_rent := l_tot_trueup_rent + l_line_trueup_rent;
2722:
2723: UPDATE
2724: pn_var_trx_headers_all
2725: SET
2726: trueup_rent_due = round(l_line_trueup_rent,g_precision)
2727: WHERE
2728: var_rent_id = p_var_rent_id AND