APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_BATCHES

Line 67: FROM ozf_resale_batches

63: -- julou bug 6317120. this assignment becomes invalid if MO: Operating Unit is not set. Get org_id from table.
64: --G_ORG_ID NUMBER := TO_NUMBER(NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99));
65: CURSOR gc_batch_org_id(p_id NUMBER) IS
66: SELECT org_id
67: FROM ozf_resale_batches
68: WHERE resale_batch_id = p_id;
69:
70: CURSOR gc_line_org_id(p_id NUMBER) IS
71: SELECT org_id

Line 134: FROM ozf_resale_batches

130: TYPE long_varchar_tbl_type IS TABLE OF VARCHAR2(300) INDEX BY BINARY_INTEGER;
131:
132: CURSOR g_batch_type_csr (p_id NUMBER) IS
133: SELECT batch_type
134: FROM ozf_resale_batches
135: WHERE resale_batch_id = p_id;
136:
137: CURSOR g_total_amount_csr(p_id in NUMBER) IS
138: -- [BEGIN OF BUG 4376520 FIXING]

Line 176: FROM ozf_resale_batches_all

172:
173: -- Start: bug # 5997978 fixed
174: CURSOR g_resale_batch_org_id_csr(cv_batch_id NUMBER) IS
175: SELECT org_id
176: FROM ozf_resale_batches_all
177: WHERE resale_batch_id = cv_batch_id;
178:
179: CURSOR g_resale_header_org_id_csr(cv_header_id NUMBER) IS
180: SELECT org_id