eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPPPSC dependencies on CST_COST_GROUPS

Line 368: from cst_cost_groups ccg

364:
365:
366: CURSOR all_cost_groups_cur IS
367: select cost_group_id
368: from cst_cost_groups ccg
369: where ccg.legal_entity = l_entity_id
370: and ccg.cost_group_type = 2
371: and NVL(ccg.disable_date, sysdate) >= sysdate;
372:

Line 1104: from cst_cost_groups ccg

1100: /* **************************************************************************** */
1101:
1102: CURSOR all_cost_groups_cur IS
1103: select cost_group_id
1104: from cst_cost_groups ccg
1105: where ccg.legal_entity = l_entity_id
1106: and ccg.cost_group_type = 2
1107: and NVL(ccg.disable_date, sysdate) >= sysdate
1108: and ccg.cost_group_id IN (

Line 1685: cst_cost_groups ccg

1681: INTO l_phase3_required
1682: FROM cst_revenue_recognition_lines crrl,
1683: cst_revenue_cogs_match_lines crcml,
1684: cst_cost_group_assignments ccga,
1685: cst_cost_groups ccg
1686: WHERE crrl.ledger_id = l_ledger_id
1687: AND crrl.potentially_unmatched_flag = 'Y'
1688: AND crrl.revenue_om_line_id = crcml.revenue_om_line_id
1689: AND crcml.organization_id = ccga.organization_id

Line 1951: from cst_cost_groups ccg

1947: /* Cursor for all cost groups defined in the legal entity */
1948: /* **************************************************************************** */
1949: CURSOR all_cost_groups_cur IS
1950: select cost_group_id
1951: from cst_cost_groups ccg
1952: where ccg.legal_entity = l_entity_id
1953: and ccg.cost_group_type = 2
1954: and NVL(ccg.disable_date, sysdate) >= sysdate
1955: and ccg.cost_group_id IN (