APPS.CSTPPPSC dependencies on CST_COST_GROUPS

Line 397: from cst_cost_groups ccg

393:
394:
395: CURSOR all_cost_groups_cur IS
396: select cost_group_id
397: from cst_cost_groups ccg
398: where ccg.legal_entity = l_entity_id
399: and ccg.cost_group_type = 2
400: and NVL(ccg.disable_date, sysdate) >= sysdate;
401:

Line 1163: from cst_cost_groups ccg

1159: /* **************************************************************************** */
1160:
1161: CURSOR all_cost_groups_cur IS
1162: select cost_group_id
1163: from cst_cost_groups ccg
1164: where ccg.legal_entity = l_entity_id
1165: and ccg.cost_group_type = 2
1166: and NVL(ccg.disable_date, sysdate) >= sysdate
1167: and ccg.cost_group_id IN (

Line 1292: cst_cost_groups ccg

1288: FROM MTL_MATERIAL_TRANSACTIONS
1289: WHERE transaction_source_type_id IN (2,12)
1290: AND organization_id IN (Select ccga.organization_id
1291: from cst_cost_group_assignments ccga,
1292: cst_cost_groups ccg
1293: where ccga.cost_group_id = ccg.cost_group_id
1294: and ccg.legal_entity = c_legal_entity_id
1295: and ccg.cost_group_type = 2
1296: and NVL(ccg.disable_date, sysdate) >= sysdate)

Line 1884: cst_cost_groups ccg

1880: INTO l_phase3_required
1881: FROM cst_revenue_recognition_lines crrl,
1882: cst_revenue_cogs_match_lines crcml,
1883: cst_cost_group_assignments ccga,
1884: cst_cost_groups ccg
1885: WHERE crrl.ledger_id = l_ledger_id
1886: AND crrl.potentially_unmatched_flag = 'Y'
1887: AND crrl.revenue_om_line_id = crcml.revenue_om_line_id
1888: AND crcml.organization_id = ccga.organization_id

Line 2154: from cst_cost_groups ccg

2150: /* Cursor for all cost groups defined in the legal entity */
2151: /* **************************************************************************** */
2152: CURSOR all_cost_groups_cur IS
2153: select cost_group_id
2154: from cst_cost_groups ccg
2155: where ccg.legal_entity = l_entity_id
2156: and ccg.cost_group_type = 2
2157: and NVL(ccg.disable_date, sysdate) >= sysdate
2158: and ccg.cost_group_id IN (