APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_BATCHES

Line 42: FROM ozf_resale_batches

38: -- julou bug 6317120. this assignment becomes invalid if MO: Operating Unit is not set. Get org_id from table.
39: --G_ORG_ID NUMBER := TO_NUMBER(NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99));
40: CURSOR gc_batch_org_id(p_id NUMBER) IS
41: SELECT org_id
42: FROM ozf_resale_batches
43: WHERE resale_batch_id = p_id;
44:
45: CURSOR gc_line_org_id(p_id NUMBER) IS
46: SELECT org_id

Line 109: FROM ozf_resale_batches

105: TYPE long_varchar_tbl_type IS TABLE OF VARCHAR2(300) INDEX BY BINARY_INTEGER;
106:
107: CURSOR g_batch_type_csr (p_id NUMBER) IS
108: SELECT batch_type
109: FROM ozf_resale_batches
110: WHERE resale_batch_id = p_id;
111:
112: CURSOR g_total_amount_csr(p_id in NUMBER) IS
113: -- [BEGIN OF BUG 4376520 FIXING]

Line 151: FROM ozf_resale_batches_all

147:
148: -- Start: bug # 5997978 fixed
149: CURSOR g_resale_batch_org_id_csr(cv_batch_id NUMBER) IS
150: SELECT org_id
151: FROM ozf_resale_batches_all
152: WHERE resale_batch_id = cv_batch_id;
153:
154: CURSOR g_resale_header_org_id_csr(cv_header_id NUMBER) IS
155: SELECT org_id