APPS.OZF_OBJFUNDSUM_PVT dependencies on OZF_OBJECT_FUND_SUMMARY

Line 181: SELECT ozf_object_fund_summary_s.nextval

177: l_amount_2 NUMBER;
178: l_amount_3 NUMBER;
179:
180: CURSOR c_objfundsum_seq IS
181: SELECT ozf_object_fund_summary_s.nextval
182: FROM dual;
183:
184: CURSOR c_objfundsum_count(p_objfundsum_id IN NUMBER) IS
185: SELECT COUNT(objfundsum_id)

Line 186: FROM ozf_object_fund_summary

182: FROM dual;
183:
184: CURSOR c_objfundsum_count(p_objfundsum_id IN NUMBER) IS
185: SELECT COUNT(objfundsum_id)
186: FROM ozf_object_fund_summary
187: WHERE objfundsum_id = p_objfundsum_id;
188:
189: CURSOR c_get_fund_currency(p_fund_id IN NUMBER) IS
190: SELECT currency_code_tc

Line 424: INSERT INTO ozf_object_fund_summary(

420: END IF;
421:
422: --dbms_output.put_line('Stat Before Insert : '||l_return_status);
423:
424: INSERT INTO ozf_object_fund_summary(
425: objfundsum_id,
426: creation_date,
427: created_by,
428: last_update_date,

Line 818: UPDATE ozf_object_fund_summary

814: IF (OZF_DEBUG_HIGH_ON) THEN
815: ozf_utility_pvt.debug_message(l_full_name ||': update object fund summary Table');
816: END IF;
817:
818: UPDATE ozf_object_fund_summary
819: SET object_version_number= object_version_number + 1,
820: last_update_date = SYSDATE,
821: last_updated_by = Fnd_Global.User_ID,
822: last_update_login = Fnd_Global.Conc_Login_ID,

Line 970: FROM ozf_object_fund_summary

966: , univ_curr_earned_amt
967: , paid_amt
968: , plan_curr_paid_amt
969: , univ_curr_paid_amt
970: FROM ozf_object_fund_summary
971: WHERE object_type = p_object_type
972: AND object_id = p_object_id
973: AND fund_id = p_fund_id;
974:

Line 1377: FROM ozf_object_fund_summary

1373: )
1374: IS
1375: CURSOR c_objfundsum IS
1376: SELECT *
1377: FROM ozf_object_fund_summary
1378: WHERE objfundsum_id = p_objfundsum_rec.objfundsum_id;
1379:
1380: l_objfundsum_rec c_objfundsum%ROWTYPE;
1381: BEGIN