66: WHERE resale_line_id = p_line_id
67: AND list_header_id = p_list_header_id
68: AND list_line_id IN
69: (SELECT from_list_line_id
70: FROM ozf_offer_adj_rltd_lines
71: START WITH to_list_line_id = p_list_line_id
72: CONNECT BY PRIOR from_list_line_id = to_list_line_id
73: UNION ALL
74: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines where to_list_line_id = p_list_line_id);*/
70: FROM ozf_offer_adj_rltd_lines
71: START WITH to_list_line_id = p_list_line_id
72: CONNECT BY PRIOR from_list_line_id = to_list_line_id
73: UNION ALL
74: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines where to_list_line_id = p_list_line_id);*/
75:
76: CURSOR line_adjustment_csr IS
77: SELECT 1
78: FROM ozf_resale_adjustments
80: AND list_header_id = p_list_header_id
81: AND((list_line_id = p_list_line_id)
82: OR(list_line_id IN
83: (SELECT from_list_line_id
84: FROM ozf_offer_adj_rltd_lines
85: START WITH to_list_line_id = p_list_line_id
86: CONNECT BY PRIOR from_list_line_id = to_list_line_id)));
87:
88: BEGIN