APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_LINES_ALL

Line 1148: line_item_id pn_var_lines_all.line_item_id%TYPE

1144: IS
1145: TYPE vol_hist_rec IS RECORD(
1146: start_date pn_var_vol_hist_all.start_date%TYPE,
1147: end_date pn_var_vol_hist_all.end_date%TYPE,
1148: line_item_id pn_var_lines_all.line_item_id%TYPE
1149: );
1150:
1151: TYPE vol_hist_type IS
1152: TABLE OF vol_hist_rec

Line 1160: FROM pn_var_lines_all

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

Line 1554: FROM pn_var_lines_all

1550: -- Get the details of
1551: CURSOR get_line_item
1552: IS
1553: SELECT line_item_id
1554: FROM pn_var_lines_all
1555: WHERE line_default_id IN ( SELECT line_default_id
1556: FROM pn_var_lines_all
1557: WHERE line_item_id=p_line_id
1558: )

Line 1556: FROM pn_var_lines_all

1552: IS
1553: SELECT line_item_id
1554: FROM pn_var_lines_all
1555: WHERE line_default_id IN ( SELECT line_default_id
1556: FROM pn_var_lines_all
1557: WHERE line_item_id=p_line_id
1558: )
1559: AND period_id = p_prd_id;
1560:

Line 1640: line_item_id pn_var_lines_all.line_item_id%TYPE

1636: IS
1637: TYPE vol_hist_rec IS RECORD(
1638: start_date pn_var_vol_hist_all.start_date%TYPE,
1639: end_date pn_var_vol_hist_all.end_date%TYPE,
1640: line_item_id pn_var_lines_all.line_item_id%TYPE
1641: );
1642:
1643: TYPE vol_hist_type IS
1644: TABLE OF vol_hist_rec

Line 1652: FROM pn_var_lines_all

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