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 424: FROM cn_comp_groups

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