APPS.CSTPCGUT dependencies on CST_COST_GROUPS

Line 50: FROM cst_cost_groups ccg,

46: l_miss_num NUMBER := FND_API.G_MISS_NUM;
47:
48:
49: CURSOR c_cost_group is SELECT ccg.cost_group_id
50: FROM cst_cost_groups ccg,
51: cst_cost_group_accounts cca
52: WHERE ccg.cost_group_id = cca.cost_group_id
53: AND NVL(ccg.organization_id, p_organization_id)
54: = cca.organization_id

Line 230: FROM CST_COST_GROUPS

226: l_statement := 10;
227: IF p_cost_group IS NOT NULL THEN
228: SELECT COUNT(*)
229: INTO l_count
230: FROM CST_COST_GROUPS
231: WHERE COST_GROUP = p_cost_group;
232:
233: IF l_count <> 0 THEN
234: RAISE fnd_api.g_exc_error;

Line 245: SELECT cst_cost_groups_s.NEXTVAL

241: END IF;
242:
243: l_statement := 20;
244:
245: SELECT cst_cost_groups_s.NEXTVAL
246: INTO l_cost_group_id
247: FROM dual;
248: l_statement := 30;
249:

Line 259: INSERT INTO CST_COST_GROUPS( COST_GROUP_ID,

255:
256:
257: l_statement := 40;
258:
259: INSERT INTO CST_COST_GROUPS( COST_GROUP_ID,
260: LAST_UPDATE_DATE,
261: LAST_UPDATED_BY,
262: CREATION_DATE,
263: CREATED_BY,