APPS.FV_FACTS_TRANSACTIONS dependencies on DUAL

Line 1559: FROM DUAL;

1555: IF vl_cohort_yr IS NOT NULL THEN
1556: BEGIN
1557: SELECT TO_NUMBER(vl_cohort_yr)
1558: INTO v_dummy_cohort
1559: FROM DUAL;
1560: --Bug#4234865 Changed v_dummy_cohort to vl_cohort_yr
1561: IF LENGTH(vl_cohort_yr) = 1 THEN
1562: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 5301: FROM DUAL;

5297: sob := p_ledger_id;
5298: -- get the sequence number
5299: SELECT fv_facts_submission_s.nextval
5300: INTO v3_req_id
5301: FROM DUAL;
5302:
5303: UPDATE fv_facts_submission
5304: SET bulk_file_sub_id = v3_req_id,
5305: submitted_by = fnd_global.user_name,