APPS.PN_VAR_BKPTS_DET_PKG dependencies on PN_VAR_BKPTS_HEAD_ALL

Line 189: FROM pn_var_bkpts_head_all

185: IF x_bkdt_default_id IS NULL THEN
186: UPDATE pn_var_lines_all
187: SET bkpt_update_flag = 'Y'
188: WHERE line_item_id IN (SELECT line_item_id
189: FROM pn_var_bkpts_head_all
190: WHERE bkpt_header_id = x_bkpt_header_id);
191: END IF;
192:
193: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.INSERT_ROW (-)');

Line 547: FROM pn_var_bkpts_head_all

543:
544: UPDATE pn_var_lines_all
545: SET bkpt_update_flag = 'Y'
546: WHERE line_item_id IN (SELECT line_item_id
547: FROM pn_var_bkpts_head_all
548: WHERE bkpt_header_id = x_bkpt_header_id);
549:
550: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.UPDATE_ROW (+)');
551:

Line 566: FROM pn_var_bkpts_head_all

562: IS
563:
564: CURSOR line_item_cur IS
565: SELECT line_item_id
566: FROM pn_var_bkpts_head_all
567: WHERE Bkpt_Header_id = (SELECT bkpt_header_id
568: FROM pn_var_bkpts_det_all
569: WHERE bkpt_detail_id = x_bkpt_detail_id);
570: