DBA Data[Home] [Help]

APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_FUNDS_ALL_B

Line 863: FROM ozf_funds_all_b f

859: CURSOR get_fund_type_csr(p_id in number) IS
860: SELECT f.fund_type
861: , f.ledger_id
862: , g.period_set_name
863: FROM ozf_funds_all_b f
864: , gl_sets_of_books g
865: , ozf_funds_utilized_all_b u
866: WHERE f.ledger_id = g.set_of_books_id
867: AND f.fund_id = u.fund_id

Line 1182: , ozf_funds_all_b f

1178:
1179: CURSOR fund_number_csr(cv_utilization_id IN NUMBER) IS
1180: select f.fund_number
1181: from ozf_funds_utilized_all_b fu
1182: , ozf_funds_all_b f
1183: where fu.fund_id = f.fund_id
1184: and fu.utilization_id = cv_utilization_id;
1185:
1186: CURSOR claim_number_csr(cv_claim_id IN NUMBER) IS