APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_COST_GROUPS

Line 1040: FROM cst_cost_groups

1036: END IF;
1037:
1038: SELECT NVL(organization_id,-1)
1039: INTO l_master_org_id
1040: FROM cst_cost_groups
1041: WHERE cost_group_id = p_cost_group_id;
1042:
1043: -- Validate that all the orgs under this cost group
1044: -- have the same master.

Line 1357: FROM cst_cost_groups ccg

1353: END IF;
1354:
1355: SELECT count(1)
1356: INTO l_count
1357: FROM cst_cost_groups ccg
1358: WHERE ccg.legal_entity = p_legal_entity
1359: AND ccg.cost_group_id = p_cost_group_id
1360: AND trunc(nvl(ccg.disable_date, SYSDATE+1)) > trunc(SYSDATE)
1361: AND EXISTS (

Line 2787: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga

2783: distinct(mmt.inventory_item_id)
2784: ,p_period_id
2785: ,1000
2786: ,'N'
2787: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga
2788: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2789: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2790: AND nvl(mmt.owning_tp_type,2) = 2
2791: AND ccg.legal_entity = p_legal_entity_id

Line 4728: FROM cst_cost_groups ccg

4724: CURSOR cst_grp_csr_type IS
4725: SELECT
4726: ccg.cost_group_id cost_group_id
4727: , ccg.cost_group cost_group
4728: FROM cst_cost_groups ccg
4729: , cst_le_cost_types clct
4730: WHERE ccg.legal_entity = clct.legal_entity
4731: AND clct.legal_entity = p_legal_entity
4732: AND clct.cost_type_id = p_cost_type_id;