APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_BKPTS_HEAD_ALL

Line 1591: ,pn_var_bkpts_head_all pbh

1587: FROM
1588: pn_var_trx_headers_all hdr
1589: ,pn_var_trx_details_all dtl
1590: ,PN_VAR_BKPTS_DET_ALL pbd
1591: ,pn_var_bkpts_head_all pbh
1592: WHERE
1593: hdr.var_rent_id = p_vr_id AND
1594: hdr.period_id = p_prd_ID AND
1595: hdr.line_item_id = p_line_ID AND

Line 2314: FROM pn_var_bkpts_head_all

2310: line.bkpt_update_flag = 'Y' AND
2311: EXISTS (SELECT null
2312: FROM pn_var_bkpts_det_all
2313: WHERE bkpt_header_id IN ( SELECT bkpt_header_id
2314: FROM pn_var_bkpts_head_all
2315: WHERE line_item_id = line.line_item_id))
2316: ORDER BY
2317: line_item_id;*/
2318:

Line 2325: pn_var_bkpts_head_all bph

2321: line.line_item_id
2322: ,line.line_default_id
2323: FROM
2324: pn_var_lines_all line,
2325: pn_var_bkpts_head_all bph
2326: WHERE
2327: line.period_id = p_prd_id AND
2328: line.bkpt_update_flag = 'Y' AND
2329: bph.period_id = line.period_id AND

Line 2348: pn_var_bkpts_head_all head

2344: ,bkpt.period_bkpt_vol_start
2345: ,bkpt.period_bkpt_vol_end
2346: ,bkpt.bkpt_rate
2347: FROM
2348: pn_var_bkpts_head_all head
2349: ,pn_var_bkpts_det_all bkpt
2350: WHERE
2351: head.line_item_id = p_line_item_id AND
2352: bkpt.bkpt_header_id = head.bkpt_header_id