APPS.PN_SOI_VOL_IMPORT dependencies on PN_VAR_LINES_ALL

Line 19: -- pn_var_lines_all.sales-Vol_update_flag to Y for

15: -- records in the pn_var_vol_hist_all and pn_var_deductions_all.
16: -- Before updating, the old records will be inserted into
17: -- pn_var_vol_arch_all and pn_var_deduct_arch_all.
18: -- 12-mar-07 Shabda o After we have updated volume history. We set the
19: -- pn_var_lines_all.sales-Vol_update_flag to Y for
20: -- all lines which might have been updated. Bug 5915771
21: -------------------------------------------------------------------------------
22:
23: --g_org_id NUMBER;

Line 71: FROM pn_var_lines_all lines,

67: SELECT lines.line_item_id ,
68: lines.period_id ,
69: l_channel.meaning ,
70: l_category.meaning
71: FROM pn_var_lines_all lines,
72: fnd_lookups l_channel,
73: fnd_lookups l_category
74: WHERE lines.line_item_id = p_line_item_id
75: AND l_channel.lookup_code(+) = lines.SALES_TYPE_CODE

Line 1134: pn_var_lines_all

1130: CLOSE get_vr_lines_c;
1131:
1132: FORALL line_id IN 1..lines_t.COUNT
1133: UPDATE
1134: pn_var_lines_all
1135: SET
1136: sales_vol_update_flag = 'Y'
1137: WHERE
1138: line_item_id = lines_t(line_id);