[Home] [Help]
64: There are three possible types,
65: A.'Accrued Promotion Liability'
66: B.'Deduction Adjustment Clearing'
67: C.'Deduction Adjustment Account'.
68: In case A and C - ccid is derive from ozf_funds_all_b
69: case of B the value is derived from ozf_sys_parameters_all.
70: This function can be customized based on customer needs */
71:
72: FUNCTION gl_post_account(
96: select f.ded_adjustment_account
97: , f.accrued_liable_account
98: , c.ded_adjustment_account
99: , c.accrued_liability_account
100: from ozf_funds_all_b f
101: , ams_categories_b c
102: where f.category_id = c.category_id
103: and f.fund_id = p_budget_id;
104:
109: , osp.gl_id_ded_clearing -- vendor clearing account
110: , osp.gl_rec_clearing_account -- receivables clearing account
111: FROM ozf_sys_parameters_all osp
112: --, ozf_funds_utilized_all_b ofa
113: , ozf_funds_all_b f
114: WHERE osp.org_id = NVL(f.org_id, -99)
115: --AND ofa.fund_id = f.fund_id
116: AND f.fund_id = p_id;
117:
379: WHERE HEADER_ID = p_header_id;
380:
381: CURSOR budget_org_csr(p_budget_id in number) IS
382: SELECT org_id
383: FROM ozf_funds_all_b
384: WHERE fund_id = p_budget_id;
385:
386: CURSOR claim_org_csr(p_claim_id in number) IS
387: SELECT org_id