APPS.OZF_ACCT_GENERATOR dependencies on OZF_SYS_PARAMETERS_ALL

Line 67: case of B the value is derived from ozf_sys_parameters_all.

63: A.'Accrued Promotion Liability'
64: B.'Deduction Adjustment Clearing'
65: C.'Deduction Adjustment Account'.
66: In case A and C - ccid is derive from ozf_funds_all_b
67: case of B the value is derived from ozf_sys_parameters_all.
68: This function can be customized based on customer needs */
69:
70: FUNCTION gl_post_account(
71: p_api_version_number IN NUMBER,

Line 114: FROM ozf_sys_parameters_all osp

110: select osp.gl_id_ded_adj -- expense account
111: , osp.gl_id_accr_promo_liab -- accrual liability account
112: , osp.gl_id_ded_clearing -- vendor clearing account
113: , osp.gl_rec_clearing_account -- receivables clearing account
114: FROM ozf_sys_parameters_all osp
115: --, ozf_funds_utilized_all_b ofa
116: , ozf_funds_all_b f
117: WHERE osp.org_id = NVL(f.org_id, -99)
118: --AND ofa.fund_id = f.fund_id

Line 129: FROM ozf_sys_parameters_all osp

125: select osp.gl_id_ded_adj -- expense account
126: , osp.gl_id_accr_promo_liab -- accrual liability account
127: , osp.gl_id_ded_clearing -- vendor clearing account
128: , osp.gl_rec_clearing_account -- receivables clearing account
129: FROM ozf_sys_parameters_all osp
130: WHERE osp.org_id = NVL(p_org_id, -99);
131:
132: -- utilization's org_id 7491702
133: CURSOR get_util_org_csr IS

Line 461: , ozf_sys_parameters_all osp

457:
458: CURSOR chart_of_acct_csr(p_org_id in number)IS
459: select chart_of_accounts_id
460: from gl_sets_of_books sob
461: , ozf_sys_parameters_all osp
462: where osp.set_of_books_id = sob.set_of_books_id
463: and osp.org_id = NVL(p_org_id, -99);
464:
465: --7491702