APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_LINES_INT

Line 52: FROM ozf_resale_lines_int

48: WHERE resale_line_id = p_id;
49:
50: CURSOR gc_iface_org_id(p_id NUMBER) IS
51: SELECT org_id
52: FROM ozf_resale_lines_int
53: WHERE resale_line_int_id = p_id;
54:
55: -- Added by vanitha
56: TYPE party_rec_type IS RECORD

Line 73: FROM ozf_resale_lines_int

69: );
70: --
71: CURSOR g_interface_rec_csr(p_id in NUMBER) IS
72: SELECT *
73: FROM ozf_resale_lines_int
74: WHERE resale_line_int_id = p_id;
75:
76: CURSOR g_header_id_csr IS
77: SELECT ozf_resale_headers_all_s.nextval

Line 131: FROM ozf_resale_lines_int

127: --, NVL(sum(total_claimed_amount - total_allowed_amount), 0) -- disputed amount
128: , NVL(sum(NVL(total_claimed_amount, 0) - NVL(total_allowed_amount, 0)), 0) -- disputed amount
129: -- BUG 4731894 (-)
130: -- [END OF BUG 4376520 FIXING]
131: FROM ozf_resale_lines_int
132: WHERE resale_batch_id = p_id
133: -- [BEGIN OF BUG 4376520 FIXING]
134: AND NVL(tracing_flag, 'F') <> 'T'
135: -- [END OF BUG 4376520 FIXING]

Line 140: FROM ozf_resale_lines_int

136: AND status_code <> 'DUPLICATED'; -- BUG 4930718
137:
138: CURSOR g_disputed_line_count_csr (p_id NUMBER)IS
139: SELECT count(1)
140: FROM ozf_resale_lines_int
141: WHERE status_code = G_BATCH_ADJ_DISPUTED
142: AND resale_batch_id = p_id;
143:
144: CURSOR g_exchange_rate_type_csr IS