2100: select 1
2101: into g_dummy
2102: from dual
2103: where exists(select 1
2104: from cst_cg_wip_acct_classes_v
2105: where class_code = wjsi_row.class_code
2106: and organization_id = wjsi_row.organization_id
2107: and class_type = wip_constants.discrete);
2108: else
2109: select 1
2110: into g_dummy
2111: from dual
2112: where exists(select 1
2113: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp
2114: where ccwac.class_code = wjsi_row.class_code
2115: and ccwac.organization_id = wjsi_row.organization_id
2116: and ccwac.class_type = wip_constants.discrete
2117: and mp.organization_id = wjsi_row.organization_id
2137: select 1
2138: into g_dummy
2139: from dual
2140: where exists(select 1
2141: from cst_cg_wip_acct_classes_v
2142: where class_code = wjsi_row.class_code
2143: and organization_id = wjsi_row.organization_id
2144: and class_type = wip_constants.eam);
2145: else
2146: select 1
2147: into g_dummy
2148: from dual
2149: where exists(select 1
2150: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp
2151: where ccwac.class_code = wjsi_row.class_code
2152: and ccwac.organization_id = wjsi_row.organization_id
2153: and ccwac.class_type = wip_constants.eam
2154: and mp.organization_id = wjsi_row.organization_id