APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 3675: l_source_plan_level from pa_resource_list_members

3671: l_prj_rlm_id := null;
3672: end;
3673: if nvl(l_prj_rlm_id,0) > 0 then
3674: select decode(parent_member_id,null,'G','R') into
3675: l_source_plan_level from pa_resource_list_members
3676: where resource_list_member_id = l_prj_rlm_id;
3677: end if;
3678: /* checking for target */
3679: l_prj_rlm_id := null;

Line 3694: l_target_plan_level from pa_resource_list_members

3690: l_prj_rlm_id := null;
3691: end;
3692: if nvl(l_prj_rlm_id,0) > 0 then
3693: select decode(parent_member_id,null,'G','R') into
3694: l_target_plan_level from pa_resource_list_members
3695: where resource_list_member_id = l_prj_rlm_id;
3696: end if;
3697: if l_source_plan_level = 'G' and
3698: l_target_plan_level = 'R' then

Line 3742: l_target_prj_plan_level from pa_resource_list_members

3738: l_prj_rlm_id := null;
3739: end;
3740: if nvl(l_prj_rlm_id,0) > 0 then
3741: select decode(parent_member_id,null,'G','R') into
3742: l_target_prj_plan_level from pa_resource_list_members
3743: where resource_list_member_id = l_prj_rlm_id;
3744: end if;
3745: end if;
3746: