APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 16: pn_var_grp_dates_all gd

12: p_period_date DATE) IS
13: SELECT SUM(vh.actual_amount) actual_amt,
14: vh.grp_date_id
15: FROM pn_var_vol_hist_all vh,
16: pn_var_grp_dates_all gd
17: WHERE vh.line_item_id = p_line_item_id
18: AND vh.grp_date_id = gd.grp_date_id
19: AND vh.period_id = gd.period_id
20: AND NVL(gd.actual_exp_code,'N') = 'N'

Line 36: pn_var_grp_dates_all gd

32: p_period_date DATE) IS
33: SELECT SUM(vh.forecasted_amount) forecasted_amt,
34: vh.grp_date_id
35: FROM pn_var_vol_hist_all vh,
36: pn_var_grp_dates_all gd
37: WHERE vh.line_item_id = p_line_item_id
38: AND vh.grp_date_id = gd.grp_date_id
39: AND vh.period_id = gd.period_id
40: AND NVL(gd.forecasted_exp_code,'N') = 'N'

Line 62: pn_var_grp_dates_all gd

58: SELECT SUM(vh.actual_amount) actual_amt,
59: vh.grp_date_id,
60: vh.line_item_id
61: FROM pn_var_vol_hist_all vh,
62: pn_var_grp_dates_all gd
63: WHERE vh.grp_date_id = gd.grp_date_id
64: AND vh.period_id = gd.period_id
65: AND gd.period_id = p_period_id
66: AND vh.line_item_id = p_line_item_id

Line 85: pn_var_grp_dates_all gd

81: SELECT SUM(vh.actual_amount) actual_amt,
82: vh.grp_date_id,
83: vh.line_item_id
84: FROM pn_var_vol_hist_all vh,
85: pn_var_grp_dates_all gd
86: WHERE vh.grp_date_id = gd.grp_date_id
87: AND vh.period_id = gd.period_id
88: AND DECODE(p_invoice_on,'ACTUAL',NVL(gd.actual_exp_code,'N'),
89: 'FORECASTED',NVL(gd.variance_exp_code,'N')) = 'Y'

Line 138: FROM pn_var_grp_dates_all

134: invoice_date,
135: group_date,
136: grp_start_date,
137: grp_end_date
138: FROM pn_var_grp_dates_all
139: WHERE period_id = p_period_id;
140:
141: /* Get the deductions for all the group dates */
142:

Line 334: pn_var_grp_dates_all gd

330: p_line_item_id number,
331: p_invoice_on varchar2) IS
332: SELECT MIN(gd.group_date) min_group_date
333: FROM pn_var_vol_hist_all vh,
334: pn_var_grp_dates_all gd
335: WHERE vh.grp_date_id = gd.grp_date_id
336: AND vh.period_id = gd.period_id
337: AND DECODE(p_invoice_on,'ACTUAL',NVL(gd.actual_exp_code,'N'),
338: 'FORECASTED',NVL(gd.variance_exp_code,'N')) = 'Y'

Line 1303: FROM pn_var_grp_dates_all

1299:
1300: CURSOR csr_last_inv(p_var_rent_id NUMBER)
1301: IS
1302: SELECT MAX(invoice_date)
1303: FROM pn_var_grp_dates_all
1304: WHERE var_rent_id = p_var_rent_id;
1305:
1306: CURSOR csr_neg_avail (ip_var_rent_id NUMBER,
1307: ip_invoice_date DATE) IS

Line 1633: FROM pn_var_grp_dates_all

1629: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (+) ');
1630:
1631: SELECT distinct actual_exp_code,forecasted_exp_code,variance_exp_code
1632: INTO p_actual_flag,p_forecasted_flag,p_variance_flag
1633: FROM pn_var_grp_dates_all
1634: WHERE period_id = p_period_id
1635: AND invoice_date = p_invoice_date;
1636:
1637: EXCEPTION

Line 2001: pn_var_grp_dates_all gd

1997: (SELECT gd.period_id,
1998: lines.line_item_id,
1999: gd.grp_date_id
2000: FROM pn_var_lines_all lines,
2001: pn_var_grp_dates_all gd
2002: WHERE gd.period_id = lines.period_id
2003: AND gd.period_id= p_period_id
2004: AND gd.invoice_date =p_invoice_date) itemp
2005: WHERE SUMm.grp_date_id = itemp.grp_date_id

Line 2355: FROM pn_var_grp_dates_all

2351:
2352: /* Get all the invoice dates for a period when doing reconciliation */
2353: CURSOR csr_get_invdt(ip_period_id NUMBER) IS
2354: SELECT distinct invoice_date
2355: FROM pn_var_grp_dates_all
2356: WHERE period_id = ip_period_id
2357: AND invoice_date = NVL(p_invoice_date,invoice_date)
2358: ORDER BY invoice_date;
2359:

Line 2598: pn_var_grp_dates_all gd

2594: SELECT 'Y'
2595: FROM dual
2596: WHERE exists (SELECT null
2597: FROM pn_var_vol_hist_all vh,
2598: pn_var_grp_dates_all gd
2599: WHERE vh.period_id = gd.period_id
2600: AND vh.grp_date_id = gd.grp_date_id
2601: AND gd.period_id = ip_period_id
2602: AND gd.invoice_date = ip_invoice_date