APPS.OZF_ACCRUAL_ENGINE dependencies on DUAL

Line 446: FROM DUAL;

442: l_old_amount_fc NUMBER;
443:
444: CURSOR c_act_budget_id IS
445: SELECT ozf_act_budgets_s.NEXTVAL
446: FROM DUAL;
447:
448: CURSOR c_act_util_rec (p_used_by_id IN NUMBER, p_used_by_type IN VARCHAR2) IS
449: SELECT activity_budget_id, object_version_number, approved_amount,approved_amount_fc
450: FROM ozf_act_budgets

Line 771: FROM DUAL;

767:
768: -- Cursor to get the sequence for utilization_id
769: CURSOR c_utilization_seq IS
770: SELECT ozf_funds_utilized_s.NEXTVAL
771: FROM DUAL;
772:
773: -- Cursor to get fund earned amount and object_version_number
774: CURSOR c_fund_b (p_fund_id IN NUMBER) IS
775: SELECT object_version_number

Line 2976: SELECT 1 FROM DUAL WHERE EXISTS

2972: WHERE b.site_use_id = p_account_site_id
2973: AND b.cust_acct_site_id = a.cust_acct_site_id;
2974:
2975: CURSOR sales_transation_csr(p_line_id NUMBER) IS
2976: SELECT 1 FROM DUAL WHERE EXISTS
2977: ( SELECT 1
2978: FROM ozf_sales_transactions_all trx
2979: WHERE trx.line_id = p_line_id
2980: AND source_code = 'OM');