APPS.WIP_JSI_VALIDATOR dependencies on DUAL

Line 2097: from dual

2093: if(wjsi_row.load_type = wip_constants.create_job) then
2094: if(wjsi_row.project_id is null) then
2095: select 1
2096: into g_dummy
2097: from dual
2098: where exists(select 1
2099: from cst_cg_wip_acct_classes_v
2100: where class_code = wjsi_row.class_code
2101: and organization_id = wjsi_row.organization_id

Line 2106: from dual

2102: and class_type = wip_constants.discrete);
2103: else
2104: select 1
2105: into g_dummy
2106: from dual
2107: where exists(select 1
2108: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp
2109: where ccwac.class_code = wjsi_row.class_code
2110: and ccwac.organization_id = wjsi_row.organization_id

Line 2124: from dual

2120: end if;
2121: elsif(wjsi_row.load_type = wip_constants.create_ns_job) then
2122: select 1
2123: into g_dummy
2124: from dual
2125: where exists(select 1
2126: from wip_non_standard_classes_val_v
2127: where class_code = wjsi_row.class_code
2128: and organization_id = wjsi_row.organization_id);

Line 2134: from dual

2130: elsif(wjsi_row.load_type = wip_constants.create_eam_job) then
2131: if(wjsi_row.project_id is null) then
2132: select 1
2133: into g_dummy
2134: from dual
2135: where exists(select 1
2136: from cst_cg_wip_acct_classes_v
2137: where class_code = wjsi_row.class_code
2138: and organization_id = wjsi_row.organization_id

Line 2143: from dual

2139: and class_type = wip_constants.eam);
2140: else
2141: select 1
2142: into g_dummy
2143: from dual
2144: where exists(select 1
2145: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp
2146: where ccwac.class_code = wjsi_row.class_code
2147: and ccwac.organization_id = wjsi_row.organization_id