DBA Data[Home] [Help]

APPS.PN_VAR_NATURAL_BP_PKG dependencies on PN_VAR_LINES_ALL

Line 83: FROM pn_var_lines_all

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

Line 89: from pn_var_lines_all

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:

Line 639: FROM pn_var_lines_all

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)