APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_FP_ELEMENTS

Line 3585: pa_fp_elements fpe,

3581: seq_no,
3582: nvl(fpe.top_task_planning_level,'LOWEST')
3583: top_task_planning_level
3584: from
3585: pa_fp_elements fpe,
3586: pa_tasks t where
3587: fpe.proj_fp_options_id = c_fp_opt_id and
3588: fpe.element_type = c_ver_type and
3589: fpe.task_id = t.task_id and

Line 3610: l_top_task_plan_level pa_fp_elements.top_task_planning_level%type;

3606: l_source_fp_opt_id NUMBER;
3607: l_target_fp_opt_id NUMBER;
3608: l_source_ver_type pa_budget_versions.version_type%type;
3609: l_target_ver_type pa_budget_versions.version_type%type;
3610: l_top_task_plan_level pa_fp_elements.top_task_planning_level%type;
3611: BEGIN
3612: l_count := 0;
3613: x_msg_count := 0;
3614: l_error_msg_header_flag := 'N';

Line 3770: from pa_fp_elements fpe

3766: c1_rec.task_id <> c1_rec.top_task_id then
3767: begin
3768: select nvl(fpe.top_task_planning_level,'LOWEST')
3769: into l_top_task_plan_level
3770: from pa_fp_elements fpe
3771: where
3772: fpe.proj_fp_options_id = l_target_fp_opt_id and
3773: fpe.element_type = l_target_ver_type and
3774: fpe.task_id = c1_rec.task_id and

Line 3785: from pa_fp_elements fpe

3781: target */
3782: begin
3783: select nvl(fpe.top_task_planning_level,'LOWEST')
3784: into l_top_task_plan_level
3785: from pa_fp_elements fpe
3786: where
3787: fpe.proj_fp_options_id = l_target_fp_opt_id and
3788: fpe.element_type = l_target_ver_type and
3789: fpe.task_id = c1_rec.top_task_id and

Line 3839: from pa_fp_elements

3835: ( p_s_fin_plan_level_code = 'T' and p_t_fin_plan_level_code = 'M' ) OR
3836: ( p_s_fin_plan_level_code = 'T' and p_t_fin_plan_level_code = 'T' ) then
3837: begin
3838: select resource_planning_level into l_target_plan_level
3839: from pa_fp_elements
3840: where proj_fp_options_id = l_target_fp_opt_id
3841: and element_type = l_target_ver_type
3842: and resource_list_member_id = 0
3843: and plannable_flag = 'Y'

Line 3981: pa_fp_elements fpe,

3977: seq_no,
3978: NVL(fpe.top_task_planning_level,'LOWEST')
3979: top_task_planning_level
3980: from
3981: pa_fp_elements fpe,
3982: pa_tasks t where
3983: fpe.proj_fp_options_id = c_fp_opt_id and
3984: fpe.element_type = c_ver_type and
3985: fpe.task_id = t.task_id and

Line 4006: l_top_task_plan_level pa_fp_elements.top_task_planning_level%type;

4002: l_source_fp_opt_id NUMBER;
4003: l_target_fp_opt_id NUMBER;
4004: l_source_ver_type pa_budget_versions.version_type%type;
4005: l_target_ver_type pa_budget_versions.version_type%type;
4006: l_top_task_plan_level pa_fp_elements.top_task_planning_level%type;
4007: l_source_task_id number;
4008: l_source_plan_level varchar2(30);
4009: l_target_plan_level varchar2(30);
4010: l_index number;

Line 4077: from pa_fp_elements fpe

4073: ,x_log_level => 5);
4074: END IF;
4075: select nvl(fpe.top_task_planning_level,'LOWEST')
4076: into l_top_task_plan_level
4077: from pa_fp_elements fpe
4078: where
4079: fpe.proj_fp_options_id = l_target_fp_opt_id and
4080: fpe.element_type = l_target_ver_type and
4081: fpe.task_id = tsk_rec.task_id and

Line 4099: from pa_fp_elements fpe

4095: ,x_log_level => 5);
4096: END IF;
4097: select nvl(fpe.top_task_planning_level,'LOWEST')
4098: into l_top_task_plan_level
4099: from pa_fp_elements fpe
4100: where
4101: fpe.proj_fp_options_id = l_target_fp_opt_id and
4102: fpe.element_type = l_target_ver_type and
4103: fpe.task_id = tsk_rec.top_task_id and

Line 4122: from pa_fp_elements fpe

4118: ,x_log_level => 5);
4119: END IF;
4120: select nvl(fpe.top_task_planning_level,'LOWEST')
4121: into l_top_task_plan_level
4122: from pa_fp_elements fpe
4123: where
4124: fpe.proj_fp_options_id = l_target_fp_opt_id and
4125: fpe.element_type = l_target_ver_type and
4126: fpe.task_id = tsk_rec.top_task_id and