DBA Data[Home] [Help]

APPS.OZF_RESALE_PUB dependencies on OZF_OFFER_ADJ_RLTD_LINES

Line 429: FROM ozf_offer_adj_rltd_lines

425: WHERE resale_line_id = p_line_id
426: AND list_header_id = p_list_header_id
427: AND list_line_id IN
428: ( (SELECT from_list_line_id
429: FROM ozf_offer_adj_rltd_lines
430: START WITH to_list_line_id = p_list_line_id
431: CONNECT BY PRIOR from_list_line_id = to_list_line_id), p_list_line_id );
432:
433: BEGIN

Line 600: FROM ozf_offer_adj_rltd_lines

596: FROM ozf_resale_adjustments
597: WHERE resale_line_id = p_resale_util_rec.resale_line_id
598: AND list_header_id = p_resale_util_rec.list_header_id
599: AND list_line_id IN ((SELECT from_list_line_id
600: FROM ozf_offer_adj_rltd_lines
601: START WITH to_list_line_id = p_resale_util_rec.list_line_id
602: CONNECT BY PRIOR from_list_line_id = to_list_line_id), p_resale_util_rec.list_line_id );
603:
604: