DBA Data[Home] [Help]

APPS.OZF_CHARGEBACK_PVT dependencies on OZF_SYS_PARAMETERS

Line 220: FROM ozf_sys_parameters;

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

Line 230: -- FROM ozf_sys_parameters_all;

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);

Line 231: FROM ozf_sys_parameters;

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);

Line 288: FROM ozf_sys_parameters_all ospa,

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:

Line 1403: ozf_sys_parameters osp

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,