APPS.OZF_ACCT_GENERATOR dependencies on OZF_FUNDS_ALL_B

Line 66: In case A and C - ccid is derive from ozf_funds_all_b

62: There are three possible types,
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(

Line 103: from ozf_funds_all_b f

99: select f.ded_adjustment_account
100: , f.accrued_liable_account
101: , c.ded_adjustment_account
102: , c.accrued_liability_account
103: from ozf_funds_all_b f
104: , ams_categories_b c
105: where f.category_id = c.category_id
106: and f.fund_id = p_budget_id;
107:

Line 116: , ozf_funds_all_b f

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
119: AND f.fund_id = p_id;*/
120:

Line 450: FROM ozf_funds_all_b

446: WHERE HEADER_ID = p_header_id;
447:
448: CURSOR budget_org_csr(p_budget_id in number) IS
449: SELECT org_id
450: FROM ozf_funds_all_b
451: WHERE fund_id = p_budget_id;
452:
453: CURSOR claim_org_csr(p_claim_id in number) IS
454: SELECT org_id

Line 469: , ozf_funds_all_b fund

465: --7491702
466: CURSOR chart_of_acct_csr1 IS
467: select chart_of_accounts_id
468: from gl_sets_of_books sob
469: , ozf_funds_all_b fund
470: where sob.set_of_books_id = fund.ledger_id
471: and fund.fund_id = p_budget_id;
472:
473: