131: DECLARE
132: ABC_FROM VARCHAR2(80);
133: BEGIN
134: IF (P_ABC_ASSGN IS NOT NULL) OR ((P_ABC_CLASS IS NOT NULL) OR (P_SORT = 7)) THEN
135: ABC_FROM := ', mtl_abc_assignments abc' || ',mtl_abc_classes abc_cls';
136: ELSE
137: ABC_FROM := ' ';
138: END IF;
139: RETURN (ABC_FROM);
501: SELECT
502: ABC_CLASS_NAME
503: INTO ABC_CLASS
504: FROM
505: MTL_ABC_CLASSES
506: WHERE ABC_CLASS_ID = P_ABC_CLASS
507: AND ORGANIZATION_ID = P_ORG_ID;
508: END IF;
509: RETURN (ABC_CLASS);