APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_BKPTS_DET_ALL

Line 1590: ,PN_VAR_BKPTS_DET_ALL pbd

1586: ROWS UNBOUNDED PRECEDING) AS ytd_group_vol_end
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

Line 2312: FROM pn_var_bkpts_det_all

2308: WHERE
2309: line.period_id = p_prd_id AND
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

Line 2331: FROM pn_var_bkpts_det_all bpd

2327: line.period_id = p_prd_id AND
2328: line.bkpt_update_flag = 'Y' AND
2329: bph.period_id = line.period_id AND
2330: EXISTS (SELECT null
2331: FROM pn_var_bkpts_det_all bpd
2332: WHERE bpd.bkpt_header_id = bph.bkpt_header_id
2333: AND rownum = 1)
2334: order BY line_item_id;
2335:

Line 2349: ,pn_var_bkpts_det_all bkpt

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
2353: ORDER BY