APPS.CN_SFP_ROLE_UTIL_PVT dependencies on CN_ROLE_QUOTA_CATES

Line 27: rqc.SEAS_SCHEDULE_ID FROM CN_ROLE_QUOTA_CATES rqc WHERE ROLE_ID = p_role_id;

23: l_temp_org NUMBER;
24:
25: CURSOR role_quota_cate_cur IS
26: SELECT rqc.ROLE_ID,rqc.QUOTA_CATEGORY_ID,rqc.RATE_SCHEDULE_ID,rqc.CALC_FORMULA_ID,
27: rqc.SEAS_SCHEDULE_ID FROM CN_ROLE_QUOTA_CATES rqc WHERE ROLE_ID = p_role_id;
28: BEGIN
29:
30: l_org_id := fnd_profile.value('ORG_ID');
31:

Line 101: from cn_role_quota_cates where role_quota_cate_id = p_role_quota_cate_id;

97: BEGIN
98: -- Get Rate Schedule ID for the given role quota cate
99: BEGIN
100: select NVL(rate_schedule_id,-1) into l_rate_schedule_id
101: from cn_role_quota_cates where role_quota_cate_id = p_role_quota_cate_id;
102: EXCEPTION
103: WHEN OTHERS THEN
104: l_rate_schedule_id := -1;
105: END;