DBA Data[Home] [Help]

APPS.CN_SFP_ROLE_UTIL_PVT dependencies on FND_PROFILE

Line 30: l_org_id := fnd_profile.value('ORG_ID');

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:
32: FOR eachq IN role_quota_cate_cur LOOP
33: l_rate_sch_id :=eachq.RATE_SCHEDULE_ID;
34: l_calc_formula_id := eachq.calc_formula_id;