DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on CST_COST_GROUPS

Line 5584: l_cost_group CST_COST_GROUPS.COST_GROUP%TYPE;

5580: l_age_option number;
5581: l_offset pls_integer;
5582: l_org_code CST_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
5583: l_cost_type CST_COST_TYPES.COST_TYPE%TYPE;
5584: l_cost_group CST_COST_GROUPS.COST_GROUP%TYPE;
5585: l_period_name CST_PAC_PERIODS.PERIOD_NAME%TYPE;
5586: l_meaning FND_LOOKUPS.MEANING%TYPE;
5587: l_stmt_num number;
5588:

Line 5680: FROM cst_cost_groups

5676: WHERE cost_type_id = i_pac_cost_type;
5677:
5678: SELECT cost_group
5679: INTO l_cost_group
5680: FROM cst_cost_groups
5681: WHERE cost_group_id = i_pac_cost_group;
5682:
5683: SELECT period_name
5684: INTO l_period_name

Line 6138: FROM cst_cost_groups

6134: l_dummy_date,
6135: legal_entity
6136: ) - l_dummy_date
6137: INTO l_date_offset
6138: FROM cst_cost_groups
6139: WHERE cost_group_id = i_pac_cost_group;
6140:
6141: open l_ref_cur for 'with Z AS
6142: (