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 2371: pn_var_trx_headers_all

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

Line 2387: pn_var_trx_headers_all

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

Line 2406: pn_var_trx_headers_all

2402: SELECT
2403: ytd_sales,
2404: ytd_deductions -- Bug#9117652
2405: FROM
2406: pn_var_trx_headers_all
2407: WHERE
2408: var_rent_id = p_vr_id AND
2409: period_id = p_prd_id AND
2410: line_item_id = p_line_id AND

Line 2434: pn_var_trx_headers_all

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

Line 2549: pn_var_trx_headers_all

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

Line 2726: pn_var_trx_headers_all

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