DBA Data[Home] [Help]

APPS.CSTPPCIC dependencies on CST_LE_COST_TYPES

Line 239: FROM cst_le_cost_types

235: l_stmt_num := 21;
236:
237: SELECT 1
238: INTO l_valid
239: FROM cst_le_cost_types
240: WHERE legal_entity = p_legal_entity;
241:
242: l_valid := 0;
243:

Line 255: from cst_le_cost_types clct

251: from cst_cost_types cct
252: where cost_type_id = p_from_cost_type_id
253: and cost_type_id in
254: (select distinct clct.cost_type_id
255: from cst_le_cost_types clct
256: where clct.legal_entity = p_legal_entity
257: )
258: and nvl(cct.disable_date, sysdate+1) > sysdate;
259:

Line 357: from cst_le_cost_types

353: and nvl(disable_date, sysdate+1) > sysdate
354: )
355: and p_to_cost_type_id not in
356: (select distinct cost_type_id
357: from cst_le_cost_types
358: );
359:
360: l_valid := 0;
361: