APPS.PN_VAR_NATURAL_BP_PKG dependencies on PN_VAR_BKPTS_HEAD_ALL

Line 162: FROM pn_var_bkpts_head_all

158:
159: DELETE FROM pn_var_bkpts_det_all
160: WHERE var_rent_id = p_var_rent_id
161: AND bkpt_header_id IN (SELECT bkpt_header_id
162: FROM pn_var_bkpts_head_all
163: WHERE bkhd_default_id = l_head_dflt_id);
164:
165: DELETE FROM PN_VAR_BKDT_DEFAULTS_ALL
166: WHERE bkhd_default_id = l_head_dflt_id;

Line 168: DELETE FROM pn_var_bkpts_head_all

164:
165: DELETE FROM PN_VAR_BKDT_DEFAULTS_ALL
166: WHERE bkhd_default_id = l_head_dflt_id;
167:
168: DELETE FROM pn_var_bkpts_head_all
169: WHERE bkhd_default_id = l_head_dflt_id;
170:
171: FOR l_counter IN l_bkpt_rec.FIRST .. l_bkpt_rec.LAST
172: LOOP

Line 646: FROM pn_var_bkpts_head_all

642:
643: CURSOR bkhd_head_cur (p_line_item_id IN NUMBER)
644: IS
645: SELECT bkpt_header_id, base_rent, natural_break_rate
646: FROM pn_var_bkpts_head_all
647: WHERE line_item_id = p_line_item_id
648: AND break_type = 'NATURAL'
649: AND base_rent IS NOT NULL;
650:

Line 859: UPDATE PN_VAR_BKPTS_HEAD_ALL

855: l_diagnostic := l_diagnostic +1;
856:
857: ELSIF p_mode = 'U' THEN
858:
859: UPDATE PN_VAR_BKPTS_HEAD_ALL
860: SET break_type = 'ARTIFICIAL'
861: , natural_break_rate = NULL
862: WHERE bkpt_header_id = bkhd_rec.bkpt_header_id;
863:

Line 864: UPDATE PN_VAR_BKPTS_HEAD_ALL

860: SET break_type = 'ARTIFICIAL'
861: , natural_break_rate = NULL
862: WHERE bkpt_header_id = bkhd_rec.bkpt_header_id;
863:
864: UPDATE PN_VAR_BKPTS_HEAD_ALL
865: SET breakpoint_type = 'FLAT'
866: WHERE bkpt_header_id = bkhd_rec.bkpt_header_id;
867:
868: UPDATE PN_VAR_BKPTS_DET_ALL