DBA Data[Home] [Help]

APPS.PA_PROJECT_UTILS dependencies on PA_PROJECT_CLASSES

Line 344: from pa_project_classes

340: , x_rowid IN varchar2 ) return number
341: is
342: cursor c1 is
343: select 1
344: from pa_project_classes
345: where project_id = x_project_id
346: AND class_category = x_class_category
347: AND class_code = x_class_code
348: AND (x_rowid is null

Line 349: or x_rowid <> pa_project_classes.rowid);

345: where project_id = x_project_id
346: AND class_category = x_class_category
347: AND class_code = x_class_code
348: AND (x_rowid is null
349: or x_rowid <> pa_project_classes.rowid);
350:
351: c1_rec c1%rowtype;
352:
353: begin

Line 635: FROM PA_PROJECT_CLASSES PC

631: --AND nvl(PPA.ORG_ID, -99) = nvl(PPTA.ORG_ID, -99)
632: AND PPA.org_id = PPTA.org_id
633: AND VC.OBJECT_TYPE_ID = PPTA.PROJECT_TYPE_ID
634: AND NOT EXISTS (SELECT NULL
635: FROM PA_PROJECT_CLASSES PC
636: WHERE PC.PROJECT_ID = x_PROJECT_ID
637: -- AND PC.CLASS_CATEGORY = CC.CLASS_CATEGORY));
638: AND PC.CLASS_CATEGORY = VC.CLASS_CATEGORY));
639: