DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_ACCOUNTING_CLASSES

Line 107: FROM WIP_ACCOUNTING_CLASSES

103: WIP_CONSTANTS.FAIL_CLOSE
104: )
105: AND ( p_class_type IS NULL OR
106: DJ.CLASS_CODE IN ( SELECT CLASS_CODE
107: FROM WIP_ACCOUNTING_CLASSES
108: WHERE CLASS_TYPE = p_class_type
109: AND ORGANIZATION_ID = p_organization_id ))
110: AND ( p_from_class IS NULL OR DJ.CLASS_CODE >= p_from_class )
111: AND ( p_to_class IS NULL OR DJ.CLASS_CODE <= p_to_class )

Line 223: FROM WIP_ACCOUNTING_CLASSES

219: WIP_CONSTANTS.FAIL_ROUT,
220: WIP_CONSTANTS.FAIL_CLOSE
221: )
222: AND ( p_class_type IS NULL OR DJ.CLASS_CODE IN ( SELECT CLASS_CODE
223: FROM WIP_ACCOUNTING_CLASSES
224: WHERE CLASS_TYPE = p_class_type
225: AND ORGANIZATION_ID = p_organization_id))
226: AND ( p_from_class IS NULL OR DJ.CLASS_CODE >= p_from_class )
227: AND ( p_to_class IS NULL OR DJ.CLASS_CODE <= p_to_class )

Line 322: FROM WIP_ACCOUNTING_CLASSES

318: WIP_CONSTANTS.FAIL_CLOSE
319: )
320: AND ( p_class_type IS NULL OR
321: DJ.CLASS_CODE IN ( SELECT CLASS_CODE
322: FROM WIP_ACCOUNTING_CLASSES
323: WHERE CLASS_TYPE = p_class_type
324: AND ORGANIZATION_ID = p_organization_id ))
325: AND ( p_from_class IS NULL OR DJ.CLASS_CODE >= p_from_class )
326: AND ( p_to_class IS NULL OR DJ.CLASS_CODE <= p_to_class )

Line 1772: WIP_ACCOUNTING_CLASSES WAC

1768: SELECT COUNT(*)
1769: INTO l_std_asst_jobs
1770: FROM WIP_DJ_CLOSE_TEMP TEMP,
1771: WIP_DISCRETE_JOBS WDJ,
1772: WIP_ACCOUNTING_CLASSES WAC
1773: WHERE WDJ.WIP_ENTITY_ID = TEMP.WIP_ENTITY_ID
1774: AND TEMP.ORGANIZATION_ID = p_organization_id
1775: AND WDJ.ORGANIZATION_ID = TEMP.ORGANIZATION_ID
1776: AND WAC.ORGANIZATION_ID = TEMP.ORGANIZATION_ID

Line 1790: WIP_ACCOUNTING_CLASSES WAC

1786: SELECT COUNT(*)
1787: INTO l_expense_jobs
1788: FROM WIP_DJ_CLOSE_TEMP TEMP,
1789: WIP_DISCRETE_JOBS WDJ,
1790: WIP_ACCOUNTING_CLASSES WAC
1791: WHERE WDJ.WIP_ENTITY_ID = TEMP.WIP_ENTITY_ID
1792: AND TEMP.ORGANIZATION_ID = p_organization_id
1793: AND WDJ.ORGANIZATION_ID = p_organization_id
1794: AND WAC.ORGANIZATION_ID = p_organization_id