APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_LINES_ALL

Line 1152: line_item_id pn_var_lines_all.line_item_id%TYPE

1148: IS
1149: TYPE vol_hist_rec IS RECORD(
1150: start_date pn_var_vol_hist_all.start_date%TYPE,
1151: end_date pn_var_vol_hist_all.end_date%TYPE,
1152: line_item_id pn_var_lines_all.line_item_id%TYPE
1153: );
1154:
1155: TYPE vol_hist_type IS
1156: TABLE OF vol_hist_rec

Line 1164: FROM pn_var_lines_all

1160:
1161: --Get all line items for a period
1162: CURSOR line_items_c(p_prd_id IN NUMBER) IS
1163: SELECT line_item_id
1164: FROM pn_var_lines_all
1165: WHERE period_id = p_prd_id
1166: ORDER BY line_item_id;
1167:
1168: --Get all volume history records for a inv_dt,period_id,line_item_id combination

Line 1558: FROM pn_var_lines_all

1554: -- Get the details of
1555: CURSOR get_line_item
1556: IS
1557: SELECT line_item_id
1558: FROM pn_var_lines_all
1559: WHERE line_default_id IN ( SELECT line_default_id
1560: FROM pn_var_lines_all
1561: WHERE line_item_id=p_line_id
1562: )

Line 1560: FROM pn_var_lines_all

1556: IS
1557: SELECT line_item_id
1558: FROM pn_var_lines_all
1559: WHERE line_default_id IN ( SELECT line_default_id
1560: FROM pn_var_lines_all
1561: WHERE line_item_id=p_line_id
1562: )
1563: AND period_id = p_prd_id;
1564:

Line 1644: line_item_id pn_var_lines_all.line_item_id%TYPE

1640: IS
1641: TYPE vol_hist_rec IS RECORD(
1642: start_date pn_var_vol_hist_all.start_date%TYPE,
1643: end_date pn_var_vol_hist_all.end_date%TYPE,
1644: line_item_id pn_var_lines_all.line_item_id%TYPE
1645: );
1646:
1647: TYPE vol_hist_type IS
1648: TABLE OF vol_hist_rec

Line 1656: FROM pn_var_lines_all

1652:
1653: --Get all line items for a period
1654: CURSOR line_items_c(p_prd_id IN NUMBER) IS
1655: SELECT line_item_id
1656: FROM pn_var_lines_all
1657: WHERE period_id = p_prd_id
1658: ORDER BY line_item_id;
1659:
1660: --Get all volume history records for a inv_dt,period_id,line_item_id combination