APPS.OZF_UTILITY_PVT dependencies on OZF_FUNDS_ALL_B

Line 49: -- 13-Oct-2003 yzhao get_qual_table_name_and_pk() for FUND, changed from ozf_fund_details_v to ozf_funds_all_b

45: -- as NUMBER
46: -- 10-Jul-2002 musman Modified the procedure check_new_status_change, checking for
47: -- CAPL instead of TAPL if the object type is 'DELV'
48: -- 19-Dec-2002 mayjain Added get_install_info
49: -- 13-Oct-2003 yzhao get_qual_table_name_and_pk() for FUND, changed from ozf_fund_details_v to ozf_funds_all_b
50: -- Wed Oct 29 2003:3/44 PM RSSHARMA Added function get_party_name . Changed get_product_name to include FAMILY in Product level since the lookup
51: -- for product level for lumpsum , scandata and Net Accrual Offers has product level codes as PRODUCT AND FAMILY
52: -- Fri Jan 23 2004:3/20 PM RSSHARMA Added the following fuctions
53: -- 1. get_fnd_lookup_meaning

Line 739: -- yzhao 10/13/2003 fix bug 3167497 changed from OZF_FUND_DETAILS_V to ozf_funds_all_b

735: ELSIF (p_sys_qual ='FCST') THEN --added tdonohoe 04/24/2000
736: x_table_name := 'OZF_ACT_FORECASTS_ALL';
737: x_pk_name := 'FORECAST_ID';
738: ELSIF (p_sys_qual ='FUND') THEN --added rchahal 06/28/2000
739: -- yzhao 10/13/2003 fix bug 3167497 changed from OZF_FUND_DETAILS_V to ozf_funds_all_b
740: x_table_name := 'OZF_FUNDS_ALL_B'; -- yzhao: 'OZF_FUND_DETAILS_V';
741: x_pk_name := 'FUND_ID';
742: ELSIF (p_sys_qual ='PRIC') THEN --added skarumur 12/17/2000
743: x_table_name := 'AMS_PRICE_LIST_ATTRIBUTES';

Line 740: x_table_name := 'OZF_FUNDS_ALL_B'; -- yzhao: 'OZF_FUND_DETAILS_V';

736: x_table_name := 'OZF_ACT_FORECASTS_ALL';
737: x_pk_name := 'FORECAST_ID';
738: ELSIF (p_sys_qual ='FUND') THEN --added rchahal 06/28/2000
739: -- yzhao 10/13/2003 fix bug 3167497 changed from OZF_FUND_DETAILS_V to ozf_funds_all_b
740: x_table_name := 'OZF_FUNDS_ALL_B'; -- yzhao: 'OZF_FUND_DETAILS_V';
741: x_pk_name := 'FUND_ID';
742: ELSIF (p_sys_qual ='PRIC') THEN --added skarumur 12/17/2000
743: x_table_name := 'AMS_PRICE_LIST_ATTRIBUTES';
744: x_pk_name := 'QP_LIST_HEADER_ID';

Line 2326: FROM ozf_funds_all_b

2322: l_ledger_name VARCHAR2(30) := NULL;
2323:
2324: CURSOR c_fund_ledger IS
2325: SELECT ledger_id, org_id
2326: FROM ozf_funds_all_b
2327: WHERE fund_id = p_fund_id;
2328:
2329: /* PENDING marketing category enhancement
2330: CURSOR c_category_ledger IS

Line 2332: FROM ozf_funds_all_b fund, ams_categories_b cat

2328:
2329: /* PENDING marketing category enhancement
2330: CURSOR c_category_ledger IS
2331: SELECT cat.ledger_id
2332: FROM ozf_funds_all_b fund, ams_categories_b cat
2333: WHERE fund_id = p_fund_id
2334: AND fund.category_id = cat.category_id;
2335: */
2336: