DBA Data[Home] [Help]

APPS.OZF_ACCT_GENERATOR dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 115: --, ozf_funds_utilized_all_b ofa

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

Line 135: FROM ozf_funds_utilized_all_b

131:
132: -- utilization's org_id 7491702
133: CURSOR get_util_org_csr IS
134: select org_id
135: FROM ozf_funds_utilized_all_b
136: WHERE utilization_id = p_utilization_id;
137:
138: --//BugFix : 7708324
139: CURSOR get_adj_acct_cur(p_utilization_id IN NUMBER) IS

Line 142: FROM ozf_funds_utilized_all_b util,

138: --//BugFix : 7708324
139: CURSOR get_adj_acct_cur(p_utilization_id IN NUMBER) IS
140: SELECT ctype.gl_id_ded_adj,
141: ctype.gl_id_accr_promo_liab
142: FROM ozf_funds_utilized_all_b util,
143: ozf_claim_types_all_b ctype
144: WHERE util.adjustment_type_id = ctype.claim_type_id
145: AND util.utilization_id = p_utilization_id
146: AND util.adjustment_type_id > -1

Line 476: FROM ozf_funds_utilized_all_b

472:
473:
474: CURSOR c_third_party_util IS
475: SELECT 1
476: FROM ozf_funds_utilized_all_b
477: WHERE utilization_id = p_utilization_id
478: AND object_type = 'TP_ORDER';
479:
480: BEGIN

Line 898: will be F in ozf_funds_utilized_all_b table. On running, Funds Accrual Engine with "Repost Failed GL"

894: /*kdass: bug 8669319 - When Account Generator Workflow errors out, then the profile
895: "Default GL accounts in case of Account Generator failure" comes into picture.
896: If the value of profile is Yes, then default GL accounts derived from budget/ system parameters
897: will be used. If the value of profile if No, then GL posting will fail and GL Posted flag
898: will be F in ozf_funds_utilized_all_b table. On running, Funds Accrual Engine with "Repost Failed GL"
899: flag set to Yes, the GL posting will happen to accounts derived from Account Generator workflow.
900: */
901: IF l_default_gl_account = 'Y' THEN
902: IF G_DEBUG_HIGH_ON THEN