APPS.AS_VALIDATE_SETUP dependencies on AS_SALES_STAGES_ALL_B

Line 76: FROM as_sales_stages_all_b

72: p_upgrade IN VARCHAR2)
73: IS
74: CURSOR C_Get_Stage_Info (c_SALES_STAGE_ID NUMBER) IS
75: SELECT nvl(min_win_probability, 0), nvl(max_win_probability, 100)
76: FROM as_sales_stages_all_b
77: WHERE sales_stage_id = c_Sales_Stage_Id;
78:
79: cursor Get_FileDebugDir IS
80: select rtrim(ltrim(value)) from v$parameter

Line 927: FROM as_sales_stages_all_b stg

923: END IF;
924:
925: BEGIN
926: SELECT count(*) INTO l_count
927: FROM as_sales_stages_all_b stg
928: WHERE not exists (Select 'E' From as_sales_stages_all_b istg
929: Where istg.name = stg.name
930: And istg.org_id = 0);
931: EXCEPTION

Line 928: WHERE not exists (Select 'E' From as_sales_stages_all_b istg

924:
925: BEGIN
926: SELECT count(*) INTO l_count
927: FROM as_sales_stages_all_b stg
928: WHERE not exists (Select 'E' From as_sales_stages_all_b istg
929: Where istg.name = stg.name
930: And istg.org_id = 0);
931: EXCEPTION
932: WHEN OTHERS THEN

Line 941: ||'in AS_SALES_STAGES_ALL_B');

937: l_err_total := l_err_total+1;
938: Write_Log(l_module, ' ');
939: Write_log(l_module, 'Error('||to_char(l_err_total)
940: ||'): found sales stage, which has no set up for org_id=0, '
941: ||'in AS_SALES_STAGES_ALL_B');
942: ELSE
943: Write_log(l_module, ' ');
944: Write_log(l_module, 'Success: no bad data found in AS_SALES_STAGES_ALL_B');
945: END IF;

Line 944: Write_log(l_module, 'Success: no bad data found in AS_SALES_STAGES_ALL_B');

940: ||'): found sales stage, which has no set up for org_id=0, '
941: ||'in AS_SALES_STAGES_ALL_B');
942: ELSE
943: Write_log(l_module, ' ');
944: Write_log(l_module, 'Success: no bad data found in AS_SALES_STAGES_ALL_B');
945: END IF;
946:
947: BEGIN
948: SELECT count(*) INTO l_count