DBA Data[Home] [Help]

APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 188: FROM ozf_resale_lines_int_all

184:
185: --Bug# 8414563 fixed by ateotia(+)
186: CURSOR g_duplicated_line_count_csr (p_resale_batch_id IN NUMBER) IS
187: SELECT count(1)
188: FROM ozf_resale_lines_int_all
189: WHERE status_code = G_BATCH_ADJ_DUPLICATED
190: AND resale_batch_id = p_resale_batch_id;
191:
192: CURSOR g_tracing_flag_csr (p_resale_line_int_id IN NUMBER) IS

Line 194: FROM ozf_resale_lines_int_all

190: AND resale_batch_id = p_resale_batch_id;
191:
192: CURSOR g_tracing_flag_csr (p_resale_line_int_id IN NUMBER) IS
193: SELECT tracing_flag
194: FROM ozf_resale_lines_int_all
195: WHERE resale_line_int_id = p_resale_line_int_id;
196: --Bug# 8414563 fixed by ateotia(-)
197:
198: ---------------------------------------------------------------------