APPS.AS_VALIDATE_SETUP dependencies on AS_LEADS_ALL

Line 86: FROM AS_LEADS_ALL OPP

82:
83: -- SOLIN, 06/12/2001
84: CURSOR C_GET_MISSING_OPP_CURR IS
85: SELECT OPP.CURRENCY_CODE
86: FROM AS_LEADS_ALL OPP
87: WHERE OPP.CURRENCY_CODE NOT IN (
88: SELECT LOOKUP.LOOKUP_CODE
89: FROM FND_LOOKUP_VALUES LOOKUP
90: WHERE LOOKUP.LOOKUP_TYPE = 'REPORTING_CURRENCY'

Line 972: FROM AS_LEADS_ALL

968:
969: ELSE
970: BEGIN
971: SELECT count(*) INTO l_count
972: FROM AS_LEADS_ALL
973: WHERE SALES_STAGE_ID IS NULL
974: OR DECISION_DATE IS NULL
975: OR WIN_PROBABILITY IS NULL
976: OR CHANNEL_CODE IS NULL;

Line 986: ||'): bad data found in AS_LEADS_ALL');

982: l_err_num := l_err_num+1;
983: l_err_total := l_err_total+1;
984: Write_log(l_module, ' ');
985: Write_log(l_module, 'Error('||to_char(l_err_total)
986: ||'): bad data found in AS_LEADS_ALL');
987: Write_log(l_module, 'SALES_STAGE_ID, DECISION_DATE, '||
988: 'WIN_PROBABILITY and CHANNEL_CODE in AS_LEADS_ALL must be NOT NULL.');
989: ELSE
990: Write_log(l_module, ' ');

Line 988: 'WIN_PROBABILITY and CHANNEL_CODE in AS_LEADS_ALL must be NOT NULL.');

984: Write_log(l_module, ' ');
985: Write_log(l_module, 'Error('||to_char(l_err_total)
986: ||'): bad data found in AS_LEADS_ALL');
987: Write_log(l_module, 'SALES_STAGE_ID, DECISION_DATE, '||
988: 'WIN_PROBABILITY and CHANNEL_CODE in AS_LEADS_ALL must be NOT NULL.');
989: ELSE
990: Write_log(l_module, ' ');
991: Write_log(l_module, 'Success: no bad data found in AS_LEADS_ALL');
992: END IF;

Line 991: Write_log(l_module, 'Success: no bad data found in AS_LEADS_ALL');

987: Write_log(l_module, 'SALES_STAGE_ID, DECISION_DATE, '||
988: 'WIN_PROBABILITY and CHANNEL_CODE in AS_LEADS_ALL must be NOT NULL.');
989: ELSE
990: Write_log(l_module, ' ');
991: Write_log(l_module, 'Success: no bad data found in AS_LEADS_ALL');
992: END IF;
993: END IF;
994: Write_log(l_module, ' ');
995: Write_log(l_module, '**** '||to_char(l_err_num)