APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 3724: l_source_plan_level from pa_resource_list_members

3720: l_prj_rlm_id := null;
3721: end;
3722: if nvl(l_prj_rlm_id,0) > 0 then
3723: select decode(parent_member_id,null,'G','R') into
3724: l_source_plan_level from pa_resource_list_members
3725: where resource_list_member_id = l_prj_rlm_id;
3726: end if;
3727: /* checking for target */
3728: l_prj_rlm_id := null;

Line 3743: l_target_plan_level from pa_resource_list_members

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

Line 3791: l_target_prj_plan_level from pa_resource_list_members

3787: l_prj_rlm_id := null;
3788: end;
3789: if nvl(l_prj_rlm_id,0) > 0 then
3790: select decode(parent_member_id,null,'G','R') into
3791: l_target_prj_plan_level from pa_resource_list_members
3792: where resource_list_member_id = l_prj_rlm_id;
3793: end if;
3794: end if;
3795: