DBA Data[Home] [Help]

APPS.CST_OVHD_RATE_IMPORT_INTERFACE dependencies on CST_COST_TYPES

Line 142: SET cdoi.cost_type_id = (select cost_type_id from CST_COST_TYPES cct

138:
139:
140:
141: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
142: SET cdoi.cost_type_id = (select cost_type_id from CST_COST_TYPES cct
143: where cct.cost_type = i_new_csttype
144: ),
145: cdoi.cost_type = i_new_csttype
146: WHERE cdoi.group_id = SEQ_NEXTVAL

Line 593: /* Insert the new cost type into cst_cost_types and assign the new cost types to all the rows */

589: AND EXISTS (select 1 from MTL_PARAMETERS mp
590: WHERE mp.cost_organization_id <> mp.organization_id
591: AND mp.organization_id = croi.organization_id);
592:
593: /* Insert the new cost type into cst_cost_types and assign the new cost types to all the rows */
594:
595: l_stmt_no := 77;
596: fnd_file.put_line(fnd_file.log,'done checking for the org to be costing org or not');
597:

Line 600: SET croi.cost_type_id = (select cost_type_id from CST_COST_TYPES cct

596: fnd_file.put_line(fnd_file.log,'done checking for the org to be costing org or not');
597:
598:
599: Update CST_RES_OVERHEADS_INTERFACE croi
600: SET croi.cost_type_id = (select cost_type_id from CST_COST_TYPES cct
601: where cct.cost_type = i_new_csttype
602: ),
603: croi.cost_type = i_new_csttype
604: WHERE croi.group_id = SEQ_NEXTVAL