APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_LINES_INT

Line 77: FROM ozf_resale_lines_int

73: WHERE resale_line_id = p_id;
74:
75: CURSOR gc_iface_org_id(p_id NUMBER) IS
76: SELECT org_id
77: FROM ozf_resale_lines_int
78: WHERE resale_line_int_id = p_id;
79:
80: -- Added by vanitha
81: TYPE party_rec_type IS RECORD

Line 98: FROM ozf_resale_lines_int

94: );
95: --
96: CURSOR g_interface_rec_csr(p_id in NUMBER) IS
97: SELECT *
98: FROM ozf_resale_lines_int
99: WHERE resale_line_int_id = p_id;
100:
101: CURSOR g_header_id_csr IS
102: SELECT ozf_resale_headers_all_s.nextval

Line 156: FROM ozf_resale_lines_int

152: --, NVL(sum(total_claimed_amount - total_allowed_amount), 0) -- disputed amount
153: , NVL(sum(NVL(total_claimed_amount, 0) - NVL(total_allowed_amount, 0)), 0) -- disputed amount
154: -- BUG 4731894 (-)
155: -- [END OF BUG 4376520 FIXING]
156: FROM ozf_resale_lines_int
157: WHERE resale_batch_id = p_id
158: -- [BEGIN OF BUG 4376520 FIXING]
159: AND NVL(tracing_flag, 'F') <> 'T'
160: -- [END OF BUG 4376520 FIXING]

Line 165: FROM ozf_resale_lines_int

161: AND status_code <> 'DUPLICATED'; -- BUG 4930718
162:
163: CURSOR g_disputed_line_count_csr (p_id NUMBER)IS
164: SELECT count(1)
165: FROM ozf_resale_lines_int
166: WHERE status_code = G_BATCH_ADJ_DISPUTED
167: AND resale_batch_id = p_id;
168:
169: CURSOR g_exchange_rate_type_csr IS

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: ---------------------------------------------------------------------