APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_SYS_PARAMETERS_ALL

Line 152: FROM ozf_sys_parameters_all osp

148: select osp.gl_id_ded_adj -- expense account
149: , osp.gl_id_accr_promo_liab -- accrual liability account
150: , osp.gl_id_ded_clearing -- vendor clearing account
151: , osp.gl_rec_clearing_account -- receivables clearing account
152: FROM ozf_sys_parameters_all osp
153: , ozf_claims_all oc
154: WHERE osp.org_id = NVL(oc.org_id, -99)
155: AND oc.claim_id = p_id;
156:

Line 1297: FROM ozf_sys_parameters_all

1293: where utilization_id = p_id;
1294:
1295: CURSOR csr_get_gl_date_type(p_id IN NUMBER) IS
1296: SELECT gl_date_type
1297: FROM ozf_sys_parameters_all
1298: WHERE org_id = NVL(p_id, -99);
1299:
1300: BEGIN
1301:

Line 2290: FROM ozf_claims_all cla, ozf_sys_parameters_all osp

2286: WHERE HOU.ORGANIZATION_ID = p_org_id;
2287:
2288: CURSOR c_claim_info (p_claim_id IN NUMBER)IS
2289: SELECT cla.gl_date, cla.org_id, cla.claim_date, osp.gl_date_type,cla.payment_method
2290: FROM ozf_claims_all cla, ozf_sys_parameters_all osp
2291: WHERE claim_id = p_claim_id
2292: AND cla.org_id = osp.org_id;
2293:
2294: CURSOR c_count_claim_utils(p_id IN NUMBER) IS

Line 2698: FROM ozf_sys_parameters_all osp

2694: CURSOR accrual_gl_posting_csr(p_id in number) IS
2695: SELECT NVL(osp.post_to_gl, 'F')
2696: , NVL(osp.gl_acct_for_offinv_flag, 'F'),plan_curr_amount, --ninarasi fix for bug 13054588
2697: plan_curr_amount_remaining -- Fix for Bug 13596344
2698: FROM ozf_sys_parameters_all osp
2699: , ozf_funds_utilized_all_b ofa
2700: WHERE osp.org_id = ofa.org_id
2701: AND ofa.utilization_id = p_id;
2702:

Line 2705: FROM ozf_sys_parameters_all osp

2701: AND ofa.utilization_id = p_id;
2702:
2703: CURSOR claim_gl_posting_csr(p_id in number) IS
2704: SELECT NVL(osp.post_to_gl, 'F')
2705: FROM ozf_sys_parameters_all osp
2706: , ozf_claims_all oc
2707: WHERE osp.org_id = oc.org_id
2708: AND oc.claim_id = p_id;
2709: