APPS.LNS_DISTRIBUTIONS_PUB dependencies on DUAL

Line 444: from dual;

440: close c_event;
441:
442: select PSA_BC_XML_REPORT_S.nextval
443: into l_sequence_id
444: from dual;
445:
446: SELECT count(*) INTO l_count
447: FROM PSA_BC_REPORT_EVENTS_GT;
448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'rows found ' || l_count);

Line 10023: select FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK') into l_date_format from dual;

10019:
10020: --l_accrual_date := trunc(fnd_date.canonical_to_date(ACCRUAL_DATE));
10021:
10022: --will give GSCC failure l_accrual_date := TO_DATE(ACCRUAL_DATE, 'DD-MON-RRRR');
10023: select FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK') into l_date_format from dual;
10024:
10025: select TO_DATE(ACCRUAL_DATE, l_date_format) into l_accrual_date from dual;
10026:
10027:

Line 10025: select TO_DATE(ACCRUAL_DATE, l_date_format) into l_accrual_date from dual;

10021:
10022: --will give GSCC failure l_accrual_date := TO_DATE(ACCRUAL_DATE, 'DD-MON-RRRR');
10023: select FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK') into l_date_format from dual;
10024:
10025: select TO_DATE(ACCRUAL_DATE, l_date_format) into l_accrual_date from dual;
10026:
10027:
10028:
10029: /* do accrual for all loans and stores all statements in g_last_all_statements */