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.FEM_GLOBAL_VS_COMBO_UTIL_PKG dependencies on FEM_LEDGER_DIM_VS_MAPS

Line 113: v_channel_vs_id fem_ledger_dim_vs_maps.CHANNEL_VS_ID%type;

109: v_attribute_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
110: v_version_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
111:
112:
113: v_channel_vs_id fem_ledger_dim_vs_maps.CHANNEL_VS_ID%type;
114: v_cctr_org_vs_id fem_ledger_dim_vs_maps.COMPANY_COST_CENTER_ORG_VS_ID%type;
115: v_company_vs_id fem_ledger_dim_vs_maps.COMPANY_VS_ID%type;
116: v_cost_ctr_vs_id fem_ledger_dim_vs_maps.COST_CENTER_VS_ID%type;
117: v_customer_vs_id fem_ledger_dim_vs_maps.CUSTOMER_VS_ID%type;

Line 114: v_cctr_org_vs_id fem_ledger_dim_vs_maps.COMPANY_COST_CENTER_ORG_VS_ID%type;

110: v_version_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
111:
112:
113: v_channel_vs_id fem_ledger_dim_vs_maps.CHANNEL_VS_ID%type;
114: v_cctr_org_vs_id fem_ledger_dim_vs_maps.COMPANY_COST_CENTER_ORG_VS_ID%type;
115: v_company_vs_id fem_ledger_dim_vs_maps.COMPANY_VS_ID%type;
116: v_cost_ctr_vs_id fem_ledger_dim_vs_maps.COST_CENTER_VS_ID%type;
117: v_customer_vs_id fem_ledger_dim_vs_maps.CUSTOMER_VS_ID%type;
118: v_entity_vs_id fem_ledger_dim_vs_maps.ENTITY_VS_ID%type;

Line 115: v_company_vs_id fem_ledger_dim_vs_maps.COMPANY_VS_ID%type;

111:
112:
113: v_channel_vs_id fem_ledger_dim_vs_maps.CHANNEL_VS_ID%type;
114: v_cctr_org_vs_id fem_ledger_dim_vs_maps.COMPANY_COST_CENTER_ORG_VS_ID%type;
115: v_company_vs_id fem_ledger_dim_vs_maps.COMPANY_VS_ID%type;
116: v_cost_ctr_vs_id fem_ledger_dim_vs_maps.COST_CENTER_VS_ID%type;
117: v_customer_vs_id fem_ledger_dim_vs_maps.CUSTOMER_VS_ID%type;
118: v_entity_vs_id fem_ledger_dim_vs_maps.ENTITY_VS_ID%type;
119: v_fin_elem_vs_id fem_ledger_dim_vs_maps.FINANCIAL_ELEM_VS_ID%type;

Line 116: v_cost_ctr_vs_id fem_ledger_dim_vs_maps.COST_CENTER_VS_ID%type;

112:
113: v_channel_vs_id fem_ledger_dim_vs_maps.CHANNEL_VS_ID%type;
114: v_cctr_org_vs_id fem_ledger_dim_vs_maps.COMPANY_COST_CENTER_ORG_VS_ID%type;
115: v_company_vs_id fem_ledger_dim_vs_maps.COMPANY_VS_ID%type;
116: v_cost_ctr_vs_id fem_ledger_dim_vs_maps.COST_CENTER_VS_ID%type;
117: v_customer_vs_id fem_ledger_dim_vs_maps.CUSTOMER_VS_ID%type;
118: v_entity_vs_id fem_ledger_dim_vs_maps.ENTITY_VS_ID%type;
119: v_fin_elem_vs_id fem_ledger_dim_vs_maps.FINANCIAL_ELEM_VS_ID%type;
120: v_geography_vs_id fem_ledger_dim_vs_maps.GEOGRAPHY_VS_ID%type;

Line 117: v_customer_vs_id fem_ledger_dim_vs_maps.CUSTOMER_VS_ID%type;

113: v_channel_vs_id fem_ledger_dim_vs_maps.CHANNEL_VS_ID%type;
114: v_cctr_org_vs_id fem_ledger_dim_vs_maps.COMPANY_COST_CENTER_ORG_VS_ID%type;
115: v_company_vs_id fem_ledger_dim_vs_maps.COMPANY_VS_ID%type;
116: v_cost_ctr_vs_id fem_ledger_dim_vs_maps.COST_CENTER_VS_ID%type;
117: v_customer_vs_id fem_ledger_dim_vs_maps.CUSTOMER_VS_ID%type;
118: v_entity_vs_id fem_ledger_dim_vs_maps.ENTITY_VS_ID%type;
119: v_fin_elem_vs_id fem_ledger_dim_vs_maps.FINANCIAL_ELEM_VS_ID%type;
120: v_geography_vs_id fem_ledger_dim_vs_maps.GEOGRAPHY_VS_ID%type;
121: v_line_item_vs_id fem_ledger_dim_vs_maps.LINE_ITEM_VS_ID%type;

Line 118: v_entity_vs_id fem_ledger_dim_vs_maps.ENTITY_VS_ID%type;

114: v_cctr_org_vs_id fem_ledger_dim_vs_maps.COMPANY_COST_CENTER_ORG_VS_ID%type;
115: v_company_vs_id fem_ledger_dim_vs_maps.COMPANY_VS_ID%type;
116: v_cost_ctr_vs_id fem_ledger_dim_vs_maps.COST_CENTER_VS_ID%type;
117: v_customer_vs_id fem_ledger_dim_vs_maps.CUSTOMER_VS_ID%type;
118: v_entity_vs_id fem_ledger_dim_vs_maps.ENTITY_VS_ID%type;
119: v_fin_elem_vs_id fem_ledger_dim_vs_maps.FINANCIAL_ELEM_VS_ID%type;
120: v_geography_vs_id fem_ledger_dim_vs_maps.GEOGRAPHY_VS_ID%type;
121: v_line_item_vs_id fem_ledger_dim_vs_maps.LINE_ITEM_VS_ID%type;
122: v_natural_account_vs_id fem_ledger_dim_vs_maps.NATURAL_ACCOUNT_VS_ID%type;

Line 119: v_fin_elem_vs_id fem_ledger_dim_vs_maps.FINANCIAL_ELEM_VS_ID%type;

115: v_company_vs_id fem_ledger_dim_vs_maps.COMPANY_VS_ID%type;
116: v_cost_ctr_vs_id fem_ledger_dim_vs_maps.COST_CENTER_VS_ID%type;
117: v_customer_vs_id fem_ledger_dim_vs_maps.CUSTOMER_VS_ID%type;
118: v_entity_vs_id fem_ledger_dim_vs_maps.ENTITY_VS_ID%type;
119: v_fin_elem_vs_id fem_ledger_dim_vs_maps.FINANCIAL_ELEM_VS_ID%type;
120: v_geography_vs_id fem_ledger_dim_vs_maps.GEOGRAPHY_VS_ID%type;
121: v_line_item_vs_id fem_ledger_dim_vs_maps.LINE_ITEM_VS_ID%type;
122: v_natural_account_vs_id fem_ledger_dim_vs_maps.NATURAL_ACCOUNT_VS_ID%type;
123: v_product_vs_id fem_ledger_dim_vs_maps.PRODUCT_VS_ID%type;

Line 120: v_geography_vs_id fem_ledger_dim_vs_maps.GEOGRAPHY_VS_ID%type;

116: v_cost_ctr_vs_id fem_ledger_dim_vs_maps.COST_CENTER_VS_ID%type;
117: v_customer_vs_id fem_ledger_dim_vs_maps.CUSTOMER_VS_ID%type;
118: v_entity_vs_id fem_ledger_dim_vs_maps.ENTITY_VS_ID%type;
119: v_fin_elem_vs_id fem_ledger_dim_vs_maps.FINANCIAL_ELEM_VS_ID%type;
120: v_geography_vs_id fem_ledger_dim_vs_maps.GEOGRAPHY_VS_ID%type;
121: v_line_item_vs_id fem_ledger_dim_vs_maps.LINE_ITEM_VS_ID%type;
122: v_natural_account_vs_id fem_ledger_dim_vs_maps.NATURAL_ACCOUNT_VS_ID%type;
123: v_product_vs_id fem_ledger_dim_vs_maps.PRODUCT_VS_ID%type;
124: v_project_vs_id fem_ledger_dim_vs_maps.PROJECT_VS_ID%type;

Line 121: v_line_item_vs_id fem_ledger_dim_vs_maps.LINE_ITEM_VS_ID%type;

117: v_customer_vs_id fem_ledger_dim_vs_maps.CUSTOMER_VS_ID%type;
118: v_entity_vs_id fem_ledger_dim_vs_maps.ENTITY_VS_ID%type;
119: v_fin_elem_vs_id fem_ledger_dim_vs_maps.FINANCIAL_ELEM_VS_ID%type;
120: v_geography_vs_id fem_ledger_dim_vs_maps.GEOGRAPHY_VS_ID%type;
121: v_line_item_vs_id fem_ledger_dim_vs_maps.LINE_ITEM_VS_ID%type;
122: v_natural_account_vs_id fem_ledger_dim_vs_maps.NATURAL_ACCOUNT_VS_ID%type;
123: v_product_vs_id fem_ledger_dim_vs_maps.PRODUCT_VS_ID%type;
124: v_project_vs_id fem_ledger_dim_vs_maps.PROJECT_VS_ID%type;
125: v_task_vs_id fem_ledger_dim_vs_maps.TASK_VS_ID%type;

Line 122: v_natural_account_vs_id fem_ledger_dim_vs_maps.NATURAL_ACCOUNT_VS_ID%type;

118: v_entity_vs_id fem_ledger_dim_vs_maps.ENTITY_VS_ID%type;
119: v_fin_elem_vs_id fem_ledger_dim_vs_maps.FINANCIAL_ELEM_VS_ID%type;
120: v_geography_vs_id fem_ledger_dim_vs_maps.GEOGRAPHY_VS_ID%type;
121: v_line_item_vs_id fem_ledger_dim_vs_maps.LINE_ITEM_VS_ID%type;
122: v_natural_account_vs_id fem_ledger_dim_vs_maps.NATURAL_ACCOUNT_VS_ID%type;
123: v_product_vs_id fem_ledger_dim_vs_maps.PRODUCT_VS_ID%type;
124: v_project_vs_id fem_ledger_dim_vs_maps.PROJECT_VS_ID%type;
125: v_task_vs_id fem_ledger_dim_vs_maps.TASK_VS_ID%type;
126: v_user_dim1_vs_id fem_ledger_dim_vs_maps.USER_DIM1_VS_ID%type;

Line 123: v_product_vs_id fem_ledger_dim_vs_maps.PRODUCT_VS_ID%type;

119: v_fin_elem_vs_id fem_ledger_dim_vs_maps.FINANCIAL_ELEM_VS_ID%type;
120: v_geography_vs_id fem_ledger_dim_vs_maps.GEOGRAPHY_VS_ID%type;
121: v_line_item_vs_id fem_ledger_dim_vs_maps.LINE_ITEM_VS_ID%type;
122: v_natural_account_vs_id fem_ledger_dim_vs_maps.NATURAL_ACCOUNT_VS_ID%type;
123: v_product_vs_id fem_ledger_dim_vs_maps.PRODUCT_VS_ID%type;
124: v_project_vs_id fem_ledger_dim_vs_maps.PROJECT_VS_ID%type;
125: v_task_vs_id fem_ledger_dim_vs_maps.TASK_VS_ID%type;
126: v_user_dim1_vs_id fem_ledger_dim_vs_maps.USER_DIM1_VS_ID%type;
127: v_user_dim2_vs_id fem_ledger_dim_vs_maps.USER_DIM2_VS_ID%type;

Line 124: v_project_vs_id fem_ledger_dim_vs_maps.PROJECT_VS_ID%type;

120: v_geography_vs_id fem_ledger_dim_vs_maps.GEOGRAPHY_VS_ID%type;
121: v_line_item_vs_id fem_ledger_dim_vs_maps.LINE_ITEM_VS_ID%type;
122: v_natural_account_vs_id fem_ledger_dim_vs_maps.NATURAL_ACCOUNT_VS_ID%type;
123: v_product_vs_id fem_ledger_dim_vs_maps.PRODUCT_VS_ID%type;
124: v_project_vs_id fem_ledger_dim_vs_maps.PROJECT_VS_ID%type;
125: v_task_vs_id fem_ledger_dim_vs_maps.TASK_VS_ID%type;
126: v_user_dim1_vs_id fem_ledger_dim_vs_maps.USER_DIM1_VS_ID%type;
127: v_user_dim2_vs_id fem_ledger_dim_vs_maps.USER_DIM2_VS_ID%type;
128: v_user_dim3_vs_id fem_ledger_dim_vs_maps.USER_DIM3_VS_ID%type;

Line 125: v_task_vs_id fem_ledger_dim_vs_maps.TASK_VS_ID%type;

121: v_line_item_vs_id fem_ledger_dim_vs_maps.LINE_ITEM_VS_ID%type;
122: v_natural_account_vs_id fem_ledger_dim_vs_maps.NATURAL_ACCOUNT_VS_ID%type;
123: v_product_vs_id fem_ledger_dim_vs_maps.PRODUCT_VS_ID%type;
124: v_project_vs_id fem_ledger_dim_vs_maps.PROJECT_VS_ID%type;
125: v_task_vs_id fem_ledger_dim_vs_maps.TASK_VS_ID%type;
126: v_user_dim1_vs_id fem_ledger_dim_vs_maps.USER_DIM1_VS_ID%type;
127: v_user_dim2_vs_id fem_ledger_dim_vs_maps.USER_DIM2_VS_ID%type;
128: v_user_dim3_vs_id fem_ledger_dim_vs_maps.USER_DIM3_VS_ID%type;
129: v_user_dim4_vs_id fem_ledger_dim_vs_maps.USER_DIM4_VS_ID%type;

Line 126: v_user_dim1_vs_id fem_ledger_dim_vs_maps.USER_DIM1_VS_ID%type;

122: v_natural_account_vs_id fem_ledger_dim_vs_maps.NATURAL_ACCOUNT_VS_ID%type;
123: v_product_vs_id fem_ledger_dim_vs_maps.PRODUCT_VS_ID%type;
124: v_project_vs_id fem_ledger_dim_vs_maps.PROJECT_VS_ID%type;
125: v_task_vs_id fem_ledger_dim_vs_maps.TASK_VS_ID%type;
126: v_user_dim1_vs_id fem_ledger_dim_vs_maps.USER_DIM1_VS_ID%type;
127: v_user_dim2_vs_id fem_ledger_dim_vs_maps.USER_DIM2_VS_ID%type;
128: v_user_dim3_vs_id fem_ledger_dim_vs_maps.USER_DIM3_VS_ID%type;
129: v_user_dim4_vs_id fem_ledger_dim_vs_maps.USER_DIM4_VS_ID%type;
130: v_user_dim5_vs_id fem_ledger_dim_vs_maps.USER_DIM5_VS_ID%type;

Line 127: v_user_dim2_vs_id fem_ledger_dim_vs_maps.USER_DIM2_VS_ID%type;

123: v_product_vs_id fem_ledger_dim_vs_maps.PRODUCT_VS_ID%type;
124: v_project_vs_id fem_ledger_dim_vs_maps.PROJECT_VS_ID%type;
125: v_task_vs_id fem_ledger_dim_vs_maps.TASK_VS_ID%type;
126: v_user_dim1_vs_id fem_ledger_dim_vs_maps.USER_DIM1_VS_ID%type;
127: v_user_dim2_vs_id fem_ledger_dim_vs_maps.USER_DIM2_VS_ID%type;
128: v_user_dim3_vs_id fem_ledger_dim_vs_maps.USER_DIM3_VS_ID%type;
129: v_user_dim4_vs_id fem_ledger_dim_vs_maps.USER_DIM4_VS_ID%type;
130: v_user_dim5_vs_id fem_ledger_dim_vs_maps.USER_DIM5_VS_ID%type;
131: v_user_dim6_vs_id fem_ledger_dim_vs_maps.USER_DIM6_VS_ID%type;

Line 128: v_user_dim3_vs_id fem_ledger_dim_vs_maps.USER_DIM3_VS_ID%type;

124: v_project_vs_id fem_ledger_dim_vs_maps.PROJECT_VS_ID%type;
125: v_task_vs_id fem_ledger_dim_vs_maps.TASK_VS_ID%type;
126: v_user_dim1_vs_id fem_ledger_dim_vs_maps.USER_DIM1_VS_ID%type;
127: v_user_dim2_vs_id fem_ledger_dim_vs_maps.USER_DIM2_VS_ID%type;
128: v_user_dim3_vs_id fem_ledger_dim_vs_maps.USER_DIM3_VS_ID%type;
129: v_user_dim4_vs_id fem_ledger_dim_vs_maps.USER_DIM4_VS_ID%type;
130: v_user_dim5_vs_id fem_ledger_dim_vs_maps.USER_DIM5_VS_ID%type;
131: v_user_dim6_vs_id fem_ledger_dim_vs_maps.USER_DIM6_VS_ID%type;
132: v_user_dim7_vs_id fem_ledger_dim_vs_maps.USER_DIM7_VS_ID%type;

Line 129: v_user_dim4_vs_id fem_ledger_dim_vs_maps.USER_DIM4_VS_ID%type;

125: v_task_vs_id fem_ledger_dim_vs_maps.TASK_VS_ID%type;
126: v_user_dim1_vs_id fem_ledger_dim_vs_maps.USER_DIM1_VS_ID%type;
127: v_user_dim2_vs_id fem_ledger_dim_vs_maps.USER_DIM2_VS_ID%type;
128: v_user_dim3_vs_id fem_ledger_dim_vs_maps.USER_DIM3_VS_ID%type;
129: v_user_dim4_vs_id fem_ledger_dim_vs_maps.USER_DIM4_VS_ID%type;
130: v_user_dim5_vs_id fem_ledger_dim_vs_maps.USER_DIM5_VS_ID%type;
131: v_user_dim6_vs_id fem_ledger_dim_vs_maps.USER_DIM6_VS_ID%type;
132: v_user_dim7_vs_id fem_ledger_dim_vs_maps.USER_DIM7_VS_ID%type;
133: v_user_dim8_vs_id fem_ledger_dim_vs_maps.USER_DIM8_VS_ID%type;

Line 130: v_user_dim5_vs_id fem_ledger_dim_vs_maps.USER_DIM5_VS_ID%type;

126: v_user_dim1_vs_id fem_ledger_dim_vs_maps.USER_DIM1_VS_ID%type;
127: v_user_dim2_vs_id fem_ledger_dim_vs_maps.USER_DIM2_VS_ID%type;
128: v_user_dim3_vs_id fem_ledger_dim_vs_maps.USER_DIM3_VS_ID%type;
129: v_user_dim4_vs_id fem_ledger_dim_vs_maps.USER_DIM4_VS_ID%type;
130: v_user_dim5_vs_id fem_ledger_dim_vs_maps.USER_DIM5_VS_ID%type;
131: v_user_dim6_vs_id fem_ledger_dim_vs_maps.USER_DIM6_VS_ID%type;
132: v_user_dim7_vs_id fem_ledger_dim_vs_maps.USER_DIM7_VS_ID%type;
133: v_user_dim8_vs_id fem_ledger_dim_vs_maps.USER_DIM8_VS_ID%type;
134: v_user_dim9_vs_id fem_ledger_dim_vs_maps.USER_DIM9_VS_ID%type;

Line 131: v_user_dim6_vs_id fem_ledger_dim_vs_maps.USER_DIM6_VS_ID%type;

127: v_user_dim2_vs_id fem_ledger_dim_vs_maps.USER_DIM2_VS_ID%type;
128: v_user_dim3_vs_id fem_ledger_dim_vs_maps.USER_DIM3_VS_ID%type;
129: v_user_dim4_vs_id fem_ledger_dim_vs_maps.USER_DIM4_VS_ID%type;
130: v_user_dim5_vs_id fem_ledger_dim_vs_maps.USER_DIM5_VS_ID%type;
131: v_user_dim6_vs_id fem_ledger_dim_vs_maps.USER_DIM6_VS_ID%type;
132: v_user_dim7_vs_id fem_ledger_dim_vs_maps.USER_DIM7_VS_ID%type;
133: v_user_dim8_vs_id fem_ledger_dim_vs_maps.USER_DIM8_VS_ID%type;
134: v_user_dim9_vs_id fem_ledger_dim_vs_maps.USER_DIM9_VS_ID%type;
135: v_user_dim10_vs_id fem_ledger_dim_vs_maps.USER_DIM10_VS_ID%type;

Line 132: v_user_dim7_vs_id fem_ledger_dim_vs_maps.USER_DIM7_VS_ID%type;

128: v_user_dim3_vs_id fem_ledger_dim_vs_maps.USER_DIM3_VS_ID%type;
129: v_user_dim4_vs_id fem_ledger_dim_vs_maps.USER_DIM4_VS_ID%type;
130: v_user_dim5_vs_id fem_ledger_dim_vs_maps.USER_DIM5_VS_ID%type;
131: v_user_dim6_vs_id fem_ledger_dim_vs_maps.USER_DIM6_VS_ID%type;
132: v_user_dim7_vs_id fem_ledger_dim_vs_maps.USER_DIM7_VS_ID%type;
133: v_user_dim8_vs_id fem_ledger_dim_vs_maps.USER_DIM8_VS_ID%type;
134: v_user_dim9_vs_id fem_ledger_dim_vs_maps.USER_DIM9_VS_ID%type;
135: v_user_dim10_vs_id fem_ledger_dim_vs_maps.USER_DIM10_VS_ID%type;
136:

Line 133: v_user_dim8_vs_id fem_ledger_dim_vs_maps.USER_DIM8_VS_ID%type;

129: v_user_dim4_vs_id fem_ledger_dim_vs_maps.USER_DIM4_VS_ID%type;
130: v_user_dim5_vs_id fem_ledger_dim_vs_maps.USER_DIM5_VS_ID%type;
131: v_user_dim6_vs_id fem_ledger_dim_vs_maps.USER_DIM6_VS_ID%type;
132: v_user_dim7_vs_id fem_ledger_dim_vs_maps.USER_DIM7_VS_ID%type;
133: v_user_dim8_vs_id fem_ledger_dim_vs_maps.USER_DIM8_VS_ID%type;
134: v_user_dim9_vs_id fem_ledger_dim_vs_maps.USER_DIM9_VS_ID%type;
135: v_user_dim10_vs_id fem_ledger_dim_vs_maps.USER_DIM10_VS_ID%type;
136:
137:

Line 134: v_user_dim9_vs_id fem_ledger_dim_vs_maps.USER_DIM9_VS_ID%type;

130: v_user_dim5_vs_id fem_ledger_dim_vs_maps.USER_DIM5_VS_ID%type;
131: v_user_dim6_vs_id fem_ledger_dim_vs_maps.USER_DIM6_VS_ID%type;
132: v_user_dim7_vs_id fem_ledger_dim_vs_maps.USER_DIM7_VS_ID%type;
133: v_user_dim8_vs_id fem_ledger_dim_vs_maps.USER_DIM8_VS_ID%type;
134: v_user_dim9_vs_id fem_ledger_dim_vs_maps.USER_DIM9_VS_ID%type;
135: v_user_dim10_vs_id fem_ledger_dim_vs_maps.USER_DIM10_VS_ID%type;
136:
137:
138: cursor c1 (p_global_vs_combo_id IN NUMBER) is

Line 135: v_user_dim10_vs_id fem_ledger_dim_vs_maps.USER_DIM10_VS_ID%type;

131: v_user_dim6_vs_id fem_ledger_dim_vs_maps.USER_DIM6_VS_ID%type;
132: v_user_dim7_vs_id fem_ledger_dim_vs_maps.USER_DIM7_VS_ID%type;
133: v_user_dim8_vs_id fem_ledger_dim_vs_maps.USER_DIM8_VS_ID%type;
134: v_user_dim9_vs_id fem_ledger_dim_vs_maps.USER_DIM9_VS_ID%type;
135: v_user_dim10_vs_id fem_ledger_dim_vs_maps.USER_DIM10_VS_ID%type;
136:
137:
138: cursor c1 (p_global_vs_combo_id IN NUMBER) is
139: SELECT D.dimension_varchar_label, G.value_set_id

Line 279: value set ids into the fem_ledger_dim_vs_maps table*/

275: END LOOP;
276:
277:
278: /* for each ledger with the given global value set combo id, merge the
279: value set ids into the fem_ledger_dim_vs_maps table*/
280: FOR ledger IN c2 (v_attribute_id, v_version_id, p_global_vs_combo_id) LOOP
281:
282: MERGE INTO fem_ledger_dim_vs_maps L
283: USING (SELECT

Line 282: MERGE INTO fem_ledger_dim_vs_maps L

278: /* for each ledger with the given global value set combo id, merge the
279: value set ids into the fem_ledger_dim_vs_maps table*/
280: FOR ledger IN c2 (v_attribute_id, v_version_id, p_global_vs_combo_id) LOOP
281:
282: MERGE INTO fem_ledger_dim_vs_maps L
283: USING (SELECT
284: ledger.ledger_id as ledger_id
285: ,p_global_vs_combo_id as global_vs_combo
286: ,v_channel_vs_id as channel