APPS.CN_SFP_ROLE_UTIL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

  SELECT rqc.ROLE_ID,rqc.QUOTA_CATEGORY_ID,rqc.RATE_SCHEDULE_ID,rqc.CALC_FORMULA_ID,
         rqc.SEAS_SCHEDULE_ID FROM CN_ROLE_QUOTA_CATES rqc WHERE ROLE_ID = p_role_id;

Line: 39

     	SELECT NVL(ORG_ID,-99) INTO l_temp_org FROM CN_RATE_SCHEDULES_ALL WHERE rate_schedule_id = l_rate_sch_id;

Line: 47

     	SELECT NVL(ORG_ID,-99) INTO l_temp_org FROM CN_CALC_FORMULAS_ALL WHERE CALC_FORMULA_ID = l_calc_formula_id and org_id = l_org_id;

Line: 55

     	SELECT NVL(ORG_ID,-99) INTO l_temp_org FROM CN_SEAS_SCHEDULES_ALL WHERE SEAS_SCHEDULE_ID = l_seas_id;

Line: 91

  select nvl(attribute1,-1) rate_tier_id ,rate_tier_id rate_sequence from cn_role_quota_rates
  where role_quota_cate_id = p_role_quota_cate_id;

Line: 100

  	select NVL(rate_schedule_id,-1) into l_rate_schedule_id
  	from cn_role_quota_cates where role_quota_cate_id = p_role_quota_cate_id;

Line: 117

  	    select count(*) INTO l_count_rate_tiers from cn_rate_tiers
  	    where rate_tier_id = l_role_qc_cur.rate_tier_id
  	    and rate_sequence = l_role_qc_cur.rate_sequence;