APPS.CN_IMP_TRXAPI_PVT dependencies on CN_COMP_GROUPS

Line 185: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;

181: l_role_id cn_roles.role_id%TYPE;
182: l_period_id cn_acc_period_statuses_v.period_id%TYPE;
183: l_rollup_period_id cn_acc_period_statuses_v.period_id%TYPE;
184: l_quota_id cn_quotas.quota_id%TYPE;
185: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;
186: l_meaning cn_lookups.meaning%TYPE;
187:
188: l_processed_row NUMBER := 0;
189: l_failed_row NUMBER := 0;

Line 425: FROM cn_comp_groups

421: IF l_trxapi_imp.compensation_group_name IS NOT NULL THEN
422: BEGIN
423: SELECT comp_group_id
424: INTO l_comp_group_id
425: FROM cn_comp_groups
426: WHERE name = l_trxapi_imp.compensation_group_name
427: ;
428: EXCEPTION
429: WHEN no_data_found THEN