DBA Data[Home] [Help]

APPS.WIP_COMMON dependencies on CST_CG_WIP_ACCT_CLASSES

Line 279: from cst_cg_wip_acct_classes cwac

275:
276: BEGIN
277:
278: select nvl(cwac.disable_date, SYSDATE + 1) into V_DISABLE_DATE
279: from cst_cg_wip_acct_classes cwac
280: where
281: cwac.organization_id = X_ORG_ID and
282: cwac.cost_group_id = X_COST_GROUP_ID and
283: cwac.class_code = X_CLASS;

Line 295: /*if no entry in cst_cg_wip_acct_classes, we will only check disabled from wip_accounting_classes*/

291: return v_ret;
292: end if;
293: exception
294: when NO_DATA_FOUND then
295: /*if no entry in cst_cg_wip_acct_classes, we will only check disabled from wip_accounting_classes*/
296: v_ret := check_disabled(X_CLASS, X_ORG_ID, X_ENTITY_TYPE);
297: return v_ret;
298:
299: END;

Line 322: from cst_cg_wip_acct_classes ccwac

318: v_project_reference_enabled = 1 then
319: begin
320: select distinct class_code
321: into dummy
322: from cst_cg_wip_acct_classes ccwac
323: where
324: ccwac.organization_id = X_ORG_ID and
325: ccwac.class_code = X_CLASS and
326: nvl(ccwac.disable_date, SYSDATE + 1) > SYSDATE;