DBA Data[Home] [Help]

APPS.PA_MASS_ASGMT_TRX dependencies on PER_RATING_LEVELS_V

Line 1333: l_rating_level per_rating_levels_v.step_value%TYPE;

1329: l_extension_possible_meaning fnd_lookups.meaning%TYPE;
1330: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;
1331: l_expense_owner_meaning pa_lookups.meaning%TYPE;
1332: l_fcst_tp_amount_type_meaning pa_lookups.meaning%TYPE;
1333: l_rating_level per_rating_levels_v.step_value%TYPE;
1334: l_submitter_user_id NUMBER;
1335: l_submitter_resp_id NUMBER;
1336: l_submitter_resp_appl_id NUMBER;
1337: l_calendar_display VARCHAR2(60);

Line 2158: FROM per_rating_levels_v

2154: --if rating level id is not null then get the actual rating level
2155: --in order to display on the wf notification.
2156: IF l_rating_level_id_tbl(i) <> FND_API.G_MISS_NUM AND l_rating_level_id_tbl(i) IS NOT NULL THEN
2157: SELECT step_value INTO l_rating_level
2158: FROM per_rating_levels_v
2159: WHERE rating_level_id = l_rating_level_id_tbl(i);
2160: END IF;
2161:
2162: l_mandatory_flag_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,