[Home] [Help]
79:
80: CURSOR line_info_cur(p_line_item_id IN NUMBER)
81: IS
82: SELECT period_id, var_rent_id
83: FROM pn_var_lines_all
84: WHERE line_item_id = p_line_item_id;
85:
86:
87: CURSOR line_cur(p_bkhd_default_id IN NUMBER) IS
85:
86:
87: CURSOR line_cur(p_bkhd_default_id IN NUMBER) IS
88: select line_item_id
89: from pn_var_lines_all
90: where line_default_id IN (select line_default_id
91: from pn_var_bkhd_defaults_all
92: where bkhd_default_id = p_bkhd_default_id);
93:
635:
636: CURSOR lines_cur (p_period_id IN NUMBER)
637: IS
638: SELECT line_item_id, sales_type_code, item_category_code
639: FROM pn_var_lines_all
640: WHERE period_id = p_period_id;
641:
642:
643: CURSOR bkhd_head_cur (p_line_item_id IN NUMBER)