DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on OZF_FUNDS_ALL_VL

Line 68: FROM ozf_funds_all_vl

64: AND custom_setup_id = p_cust_setup_id;
65:
66: CURSOR c_par_fund_id_exists (p_par_fund_id IN NUMBER, p_par_fund_name IN VARCHAR) IS
67: SELECT 1
68: FROM ozf_funds_all_vl
69: WHERE fund_type <> 'QUOTA'
70: AND fund_id = p_par_fund_id
71: AND short_name = p_par_fund_name;
72:

Line 81: FROM ozf_funds_all_vl

77: AND fund_id = p_par_fund_id;
78:
79: CURSOR c_par_fund_name_exists (p_par_fund_name IN VARCHAR2) IS
80: SELECT fund_id
81: FROM ozf_funds_all_vl
82: WHERE fund_type <> 'QUOTA'
83: AND short_name = p_par_fund_name;
84:
85: CURSOR c_cat_exists (p_category_id IN NUMBER, p_category_name IN VARCHAR2) IS

Line 1229: FROM ozf_funds_all_vl

1225: end_period_name, original_budget, holdback_amt, currency_code_tc, owner, accrual_basis,
1226: accrual_phase, accrual_discount_level, threshold_id, task_id, liability_flag,
1227: accrued_liable_account, ded_adjustment_account, product_spread_time_id, object_version_number,
1228: org_id, ledger_id
1229: FROM ozf_funds_all_vl
1230: WHERE fund_id = p_fund_id;
1231:
1232: BEGIN
1233:

Line 2776: FROM ozf_funds_all_vl

2772: product_spread_time_id,
2773: object_version_number,
2774: org_id,
2775: liability_flag
2776: FROM ozf_funds_all_vl
2777: WHERE fund_id = p_fund_id;
2778:
2779: CURSOR c_market_segment (p_fund_id IN NUMBER) IS
2780: SELECT activity_market_segment_id,