APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_SYS_PARAMETERS

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:

Line 3113: , ozf_sys_parameters b

3109: --Bug7391920 - Added cursor c_period_closed
3110: CURSOR c_period_closed ( l_acct_date DATE ) IS
3111: SELECT closing_status
3112: FROM gl_period_statuses a
3113: , ozf_sys_parameters b
3114: WHERE application_id = 222
3115: AND a.set_of_books_id = b.set_of_books_id
3116: AND l_acct_date BETWEEN start_date AND end_date
3117: AND NVL(adjustment_period_flag,'N') = 'N';

Line 3124: , ozf_sys_parameters b

3120: --Bug7391920 - Added cursor c_open_period
3121: CURSOR c_open_period IS
3122: SELECT MIN(start_date)
3123: FROM gl_period_statuses a
3124: , ozf_sys_parameters b
3125: WHERE a.application_id = 222
3126: AND a.set_of_books_id = b.set_of_books_id
3127: AND nvl(a.adjustment_period_flag,'N') = 'N'
3128: AND a.closing_status IN ( 'O','F');