DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on CST_CAT_ELE_EXP_ASSOCS_V

Line 165: select count(category_id) into l_available from cst_cat_ele_exp_assocs_v cceav

161: AND wdj.organization_id = p_organization_id
162: AND wdj.wip_entity_id = we.wip_entity_id;
163:
164: /* Added for bug 9216810 */
165: select count(category_id) into l_available from cst_cat_ele_exp_assocs_v cceav
166: where category_id = p_category_id and
167: nvl(cceav.start_date,sysdate-1) <= sysdate and
168: nvl(cceav.end_date,sysdate+1) >= sysdate;
169:

Line 186: from cst_cat_ele_exp_assocs_v cceav, wip_accounting_classes wac,wip_discrete_jobs wdj

182: 4,wac.outside_proc_variance_account,
183: 5,wac.overhead_variance_account,wac.material_variance_account) variance_account_id
184:
185: into l_material_account,l_material_variance_account
186: from cst_cat_ele_exp_assocs_v cceav, wip_accounting_classes wac,wip_discrete_jobs wdj
187: where wdj.organization_id = p_organization_id and
188: wdj.wip_entity_id = p_wip_entity_id and
189: wac.class_code = wdj.class_code and
190: wac.organization_id= wdj.organization_id and