APPS.PN_VAR_NATURAL_BP_PKG dependencies on PN_VAR_BKPTS_DET_ALL

Line 159: DELETE FROM pn_var_bkpts_det_all

155:
156: END LOOP;
157:
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);

Line 868: UPDATE PN_VAR_BKPTS_DET_ALL

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
869: SET ANNUAL_BASIS_AMOUNT = NULL
870: WHERE bkpt_header_id = bkhd_rec.bkpt_header_id;
871:
872: l_update_count := l_update_count + 1;