APPS.IEX_STRATEGY_CNT_PUB dependencies on DUAL

Line 2624: into l_DefaultStrategyLevel from dual;

2620:
2621: l_StrategyLevelName := l_str_levels.lookup_code;
2622:
2623: select decode(l_StrategyLevelName, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 50)
2624: into l_DefaultStrategyLevel from dual;
2625:
2626: write_log(FND_LOG.LEVEL_STATEMENT, ' Org_id ' || l_org_id || ' Itearation Level ' || l_DefaultStrategyLevel);
2627:
2628: if (p_customer_name_low IS NOT NULL OR p_customer_name_high IS NOT NULL OR p_account_number_low IS NOT NULL OR

Line 2675: into l_DefaultStrategyLevel from dual;

2671:
2672: l_StrategyLevelName := l_str_levels.lookup_code;
2673:
2674: select decode(l_StrategyLevelName, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 50)
2675: into l_DefaultStrategyLevel from dual;
2676:
2677: write_log(FND_LOG.LEVEL_STATEMENT, ' Org_id ' || l_org_id || ' Itearation Level ' || l_DefaultStrategyLevel);
2678:
2679: if (p_customer_name_low IS NOT NULL OR p_customer_name_high IS NOT NULL OR p_account_number_low IS NOT NULL OR

Line 2800: into l_DefaultStrategyLevel from dual;

2796:
2797: l_StrategyLevelName := l_str_levels.lookup_code;
2798:
2799: select decode(l_StrategyLevelName, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 50)
2800: into l_DefaultStrategyLevel from dual;
2801:
2802: write_log(FND_LOG.LEVEL_STATEMENT, ' Running Strategy Level ' || l_DefaultStrategyLevel);
2803: write_log(FND_LOG.LEVEL_STATEMENT, ' System Strategy Level ' || l_system_strategy_level);
2804:

Line 3410: from dual;

3406: FND_FILE.put_line( FND_FILE.LOG,'XML header data generation starts');
3407:
3408: select to_char(sysdate, 'YYYY-MM-DD')
3409: into l_report_date
3410: from dual;
3411: writelog('gen_xml_header_data_strategy: l_report_date: ' || l_report_date);
3412:
3413: l_terr_acc_level := NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY');
3414: writelog('gen_xml_header_data_strategy: l_terr_acc_level: ' || l_terr_acc_level);