DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_ACCOUNTING_CLASSES

Line 91: FROM WIP_ACCOUNTING_CLASSES

87: WIP_CONSTANTS.FAIL_CLOSE
88: )
89: AND ( p_class_type IS NULL OR
90: DJ.CLASS_CODE IN ( SELECT CLASS_CODE
91: FROM WIP_ACCOUNTING_CLASSES
92: WHERE CLASS_TYPE = p_class_type
93: AND ORGANIZATION_ID = p_organization_id ))
94: AND ( p_from_class IS NULL OR DJ.CLASS_CODE >= p_from_class )
95: AND ( p_to_class IS NULL OR DJ.CLASS_CODE <= p_to_class )

Line 1365: WIP_ACCOUNTING_CLASSES WAC

1361: SELECT COUNT(*)
1362: INTO l_std_asst_jobs
1363: FROM WIP_DJ_CLOSE_TEMP TEMP,
1364: WIP_DISCRETE_JOBS WDJ,
1365: WIP_ACCOUNTING_CLASSES WAC
1366: WHERE WDJ.WIP_ENTITY_ID = TEMP.WIP_ENTITY_ID
1367: AND TEMP.ORGANIZATION_ID = p_organization_id
1368: AND WDJ.ORGANIZATION_ID = TEMP.ORGANIZATION_ID
1369: AND WAC.ORGANIZATION_ID = TEMP.ORGANIZATION_ID

Line 1383: WIP_ACCOUNTING_CLASSES WAC

1379: SELECT COUNT(*)
1380: INTO l_expense_jobs
1381: FROM WIP_DJ_CLOSE_TEMP TEMP,
1382: WIP_DISCRETE_JOBS WDJ,
1383: WIP_ACCOUNTING_CLASSES WAC
1384: WHERE WDJ.WIP_ENTITY_ID = TEMP.WIP_ENTITY_ID
1385: AND TEMP.ORGANIZATION_ID = p_organization_id
1386: AND WDJ.ORGANIZATION_ID = p_organization_id
1387: AND WAC.ORGANIZATION_ID = p_organization_id