APPS.FV_FACTS_TRANSACTIONS dependencies on DUAL

Line 1525: FROM DUAL;

1521: IF vl_cohort_yr IS NOT NULL THEN
1522: BEGIN
1523: SELECT TO_NUMBER(vl_cohort_yr)
1524: INTO v_dummy_cohort
1525: FROM DUAL;
1526: --Bug#4234865 Changed v_dummy_cohort to vl_cohort_yr
1527: IF LENGTH(vl_cohort_yr) = 1 THEN
1528: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 5225: FROM DUAL;

5221: sob := p_ledger_id;
5222: -- get the sequence number
5223: SELECT fv_facts_submission_s.nextval
5224: INTO v3_req_id
5225: FROM DUAL;
5226:
5227: UPDATE fv_facts_submission
5228: SET bulk_file_sub_id = v3_req_id,
5229: submitted_by = fnd_global.user_name,