DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_OFFER_ADJ_RLTD_LINES

Line 70: FROM ozf_offer_adj_rltd_lines

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);*/

Line 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

Line 84: FROM ozf_offer_adj_rltd_lines

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