DBA Data[Home] [Help]

APPS.CSTPUPDT dependencies on STANDARD

Line 428: b_cm_frozen_standard IN NUMBER,

424: /*Added cst_del_cilt function for bug 11889101*/
425: FUNCTION cst_del_cilt
426: (l_org_id IN number,
427: l_cost_type_id IN number,
428: b_cm_frozen_standard IN NUMBER,
429: err_buf out NOCOPY varchar2)
430: RETURN INTEGER IS
431:
432: return_code number;

Line 446: AND CIC1.cost_type_id = b_cm_frozen_standard

442: FROM CST_ITEM_COSTS CIC1,
443: CST_ITEM_COSTS CIC2,
444: CST_ITEM_LIST_TEMP CLT
445: WHERE CIC1.organization_id = l_org_id
446: AND CIC1.cost_type_id = b_cm_frozen_standard
447: AND CIC1.inventory_item_id = CLT.inventory_item_id
448: AND CIC2.organization_id (+) = l_org_id
449: AND CIC2.cost_type_id (+) = l_cost_type_id
450: AND CIC2.inventory_item_id (+) = CIC1.inventory_item_id

Line 502: AND CICD1.cost_type_id = b_cm_frozen_standard

498: basis_type, basis_factor,
499: usage_rate_or_amount, item_cost
500: FROM CST_ITEM_COST_DETAILS CICD1
501: WHERE CICD1.organization_id = l_org_id
502: AND CICD1.cost_type_id = b_cm_frozen_standard
503: AND CICD1.inventory_item_id = CIC2.inventory_item_id)
504: MINUS
505: ( SELECT rollup_source_type, level_type,
506: cost_element_id, Nvl(resource_id, -1),