DBA Data[Home] [Help]

APPS.CSTPPCIT dependencies on CST_COST_GROUPS

Line 51: FROM CST_COST_GROUPS

47: /* Validate org_cost_group_id */
48: l_count := 0;
49: SELECT count(*)
50: INTO l_count
51: FROM CST_COST_GROUPS
52: WHERE cost_group_id = i_org_cost_group_id
53: AND TRUNC(NVL(disable_date, sysdate)) >= TRUNC(sysdate)
54: AND cost_group_type = 2;
55:

Line 68: FROM CST_COST_GROUPS

64: l_stmt_num := 20;
65: /* Find the master org id and legal_entity for the cost group */
66: SELECT legal_entity, organization_id
67: INTO l_legal_entity, l_master_org_id
68: FROM CST_COST_GROUPS
69: WHERE cost_group_id = i_org_cost_group_id;
70:
71: l_stmt_num := 30;
72: /* Validate cost_type_id */

Line 355: FROM CST_COST_GROUPS

351: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id;
352:
353: SELECT legal_entity
354: INTO l_legal_entity
355: FROM CST_COST_GROUPS
356: WHERE cost_group_id = i_org_cost_group_id;
357:
358: SELECT NVL(MAX(pac_period_id),-1)
359: INTO l_pac_period_id