DBA Data[Home] [Help]

APPS.PA_MASS_ASGMT_TRX dependencies on PER_RATING_LEVELS_V

Line 1390: l_rating_level per_rating_levels_v.step_value%TYPE;

1386: l_extension_possible_meaning fnd_lookups.meaning%TYPE;
1387: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;
1388: l_expense_owner_meaning pa_lookups.meaning%TYPE;
1389: l_fcst_tp_amount_type_meaning pa_lookups.meaning%TYPE;
1390: l_rating_level per_rating_levels_v.step_value%TYPE;
1391: l_submitter_user_id NUMBER;
1392: l_submitter_resp_id NUMBER;
1393: l_submitter_resp_appl_id NUMBER;
1394: l_calendar_display VARCHAR2(60);

Line 2215: FROM per_rating_levels_v

2211: --if rating level id is not null then get the actual rating level
2212: --in order to display on the wf notification.
2213: IF l_rating_level_id_tbl(i) <> FND_API.G_MISS_NUM AND l_rating_level_id_tbl(i) IS NOT NULL THEN
2214: SELECT step_value INTO l_rating_level
2215: FROM per_rating_levels_v
2216: WHERE rating_level_id = l_rating_level_id_tbl(i);
2217: END IF;
2218:
2219: l_mandatory_flag_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,