APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_SYS_PARAMETERS_ALL

Line 261: FROM ozf_sys_parameters_all osp

257: select osp.gl_id_ded_adj -- expense account
258: , osp.gl_id_accr_promo_liab -- accrual liability account
259: , osp.gl_id_ded_clearing -- vendor clearing account
260: , osp.gl_rec_clearing_account -- receivables clearing account
261: FROM ozf_sys_parameters_all osp
262: , ozf_funds_utilized_all_b ofa
263: WHERE osp.org_id = NVL(ofa.org_id, -99)
264: AND ofa.utilization_id = p_id;
265:

Line 271: FROM ozf_sys_parameters_all osp

267: select osp.gl_id_ded_adj -- expense account
268: , osp.gl_id_accr_promo_liab -- accrual liability account
269: , osp.gl_id_ded_clearing -- vendor clearing account
270: , osp.gl_rec_clearing_account -- receivables clearing account
271: FROM ozf_sys_parameters_all osp
272: , ozf_claims_all oc
273: WHERE osp.org_id = NVL(oc.org_id, -99)
274: AND oc.claim_id = p_id;
275:

Line 1845: FROM ozf_sys_parameters_all

1841: where utilization_id = p_id;
1842:
1843: CURSOR csr_get_gl_date_type(p_id IN NUMBER) IS
1844: SELECT gl_date_type
1845: FROM ozf_sys_parameters_all
1846: WHERE org_id = NVL(p_id, -99);
1847:
1848: BEGIN
1849:

Line 2483: FROM ozf_sys_parameters_all osp

2479: CURSOR accrual_gl_posting_csr(p_id in number) IS
2480: SELECT osp.post_to_gl
2481: , osp.transfer_to_gl_in
2482: , osp.gl_acct_for_offinv_flag
2483: FROM ozf_sys_parameters_all osp
2484: , ozf_funds_utilized_all_b ofa
2485: WHERE osp.org_id = NVL(ofa.org_id, -99)
2486: AND ofa.utilization_id = p_id;
2487:

Line 2491: FROM ozf_sys_parameters_all osp

2487:
2488: CURSOR claim_gl_posting_csr(p_id in number) IS
2489: SELECT osp.post_to_gl
2490: , osp.transfer_to_gl_in
2491: FROM ozf_sys_parameters_all osp
2492: , ozf_claims_all oc
2493: WHERE osp.org_id = NVL(oc.org_id, -99)
2494: AND oc.claim_id = p_id;
2495: