APPS.OZF_OBJFUNDSUM_PVT dependencies on OZF_OBJECT_FUND_SUMMARY

Line 175: SELECT ozf_object_fund_summary_s.nextval

171: l_amount_2 NUMBER;
172: l_amount_3 NUMBER;
173:
174: CURSOR c_objfundsum_seq IS
175: SELECT ozf_object_fund_summary_s.nextval
176: FROM dual;
177:
178: CURSOR c_objfundsum_count(p_objfundsum_id IN NUMBER) IS
179: SELECT COUNT(objfundsum_id)

Line 180: FROM ozf_object_fund_summary

176: FROM dual;
177:
178: CURSOR c_objfundsum_count(p_objfundsum_id IN NUMBER) IS
179: SELECT COUNT(objfundsum_id)
180: FROM ozf_object_fund_summary
181: WHERE objfundsum_id = p_objfundsum_id;
182:
183: CURSOR c_get_fund_currency(p_fund_id IN NUMBER) IS
184: SELECT currency_code_tc

Line 412: INSERT INTO ozf_object_fund_summary(

408: END IF;
409:
410: --dbms_output.put_line('Stat Before Insert : '||l_return_status);
411:
412: INSERT INTO ozf_object_fund_summary(
413: objfundsum_id,
414: creation_date,
415: created_by,
416: last_update_date,

Line 781: UPDATE ozf_object_fund_summary

777: IF (OZF_DEBUG_HIGH_ON) THEN
778: ozf_utility_pvt.debug_message(l_full_name ||': update object fund summary Table');
779: END IF;
780:
781: UPDATE ozf_object_fund_summary
782: SET object_version_number= object_version_number + 1,
783: last_update_date = SYSDATE,
784: last_updated_by = Fnd_Global.User_ID,
785: last_update_login = Fnd_Global.Conc_Login_ID,

Line 933: FROM ozf_object_fund_summary

929: , univ_curr_earned_amt
930: , paid_amt
931: , plan_curr_paid_amt
932: , univ_curr_paid_amt
933: FROM ozf_object_fund_summary
934: WHERE object_type = p_object_type
935: AND object_id = p_object_id
936: AND fund_id = p_fund_id;
937:

Line 1340: FROM ozf_object_fund_summary

1336: )
1337: IS
1338: CURSOR c_objfundsum IS
1339: SELECT *
1340: FROM ozf_object_fund_summary
1341: WHERE objfundsum_id = p_objfundsum_rec.objfundsum_id;
1342:
1343: l_objfundsum_rec c_objfundsum%ROWTYPE;
1344: BEGIN