216: l_order_num_tbl order_num_tbl_type;
217:
218: CURSOR auto_tp_accrual_csr IS
219: SELECT auto_tp_accrual_flag
220: FROM ozf_sys_parameters;
221:
222: CURSOR claimed_amount_csr(p_claim_id IN NUMBER) IS
223: SELECT amount
224: FROM ozf_claims
226:
227: CURSOR end_cust_relation_flag_csr IS
228: SELECT end_cust_relation_flag
229: -- BUG 4992408 (+)
230: -- FROM ozf_sys_parameters_all;
231: FROM ozf_sys_parameters;
232: -- BUG 4992408 (-)
233:
234: l_end_cust_relation_flag VARCHAR2(30);
227: CURSOR end_cust_relation_flag_csr IS
228: SELECT end_cust_relation_flag
229: -- BUG 4992408 (+)
230: -- FROM ozf_sys_parameters_all;
231: FROM ozf_sys_parameters;
232: -- BUG 4992408 (-)
233:
234: l_end_cust_relation_flag VARCHAR2(30);
235: l_partner_claim_num VARCHAR2(30);
284: --Bug# 8632964 fixed by anuj and muthu (+)
285: CURSOR sysparam_accrual_flag_csr (p_resale_batch_id IN NUMBER)
286: IS
287: SELECT NVL(ospa.ship_debit_accrual_flag, 'F')
288: FROM ozf_sys_parameters_all ospa,
289: ozf_resale_batches_all orba
290: WHERE ospa.org_id = orba.org_id
291: AND orba.resale_batch_id = p_resale_batch_id;
292:
1399:
1400: CURSOR func_currency_cd_csr IS
1401: SELECT gs.currency_code
1402: FROM gl_sets_of_books gs,
1403: ozf_sys_parameters osp
1404: WHERE gs.set_of_books_id = osp.set_of_books_id
1405: AND osp.org_id = MO_GLOBAL.get_current_org_id();
1406:
1407: CURSOR open_lines_csr(p_order_number VARCHAR2,