APPS.CSTPPWRO dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 976: cst_cost_group_assignments ccga

972: CURSOR c_wip_entities_mov IS
973: SELECT we.wip_entity_id entity_id,
974: we.entity_type entity_type
975: FROM wip_entities we,
976: cst_cost_group_assignments ccga
977: WHERE ccga.cost_group_id = p_cost_group_id
978: AND we.organization_id = ccga.organization_id
979: AND we.entity_type <> 4 -- NOT CFM
980: AND we.primary_item_id IS NOT NULL

Line 997: cst_cost_group_assignments ccga

993: SELECT we.wip_entity_id entity_id,
994: we.entity_type entity_type,
995: we.organization_id org_id
996: FROM wip_entities we,
997: cst_cost_group_assignments ccga
998: WHERE ccga.cost_group_id = p_cost_group_id
999: AND we.organization_id = ccga.organization_id
1000: AND EXISTS
1001: ( SELECT 'X'

Line 1193: FROM cst_cost_group_assignments ccga

1189: AND (TRUNC(p_end_date) + 0.99999)
1190: AND wcti.transaction_type IN (1,2,3,6)
1191: AND EXISTS (
1192: SELECT 'X'
1193: FROM cst_cost_group_assignments ccga
1194: WHERE ccga.cost_group_id = p_cost_group_id
1195: AND ccga.organization_id = wcti.organization_id
1196: );
1197: