APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_FP_ELEMENTS

Line 3634: pa_fp_elements fpe,

3630: seq_no,
3631: nvl(fpe.top_task_planning_level,'LOWEST')
3632: top_task_planning_level
3633: from
3634: pa_fp_elements fpe,
3635: pa_tasks t where
3636: fpe.proj_fp_options_id = c_fp_opt_id and
3637: fpe.element_type = c_ver_type and
3638: fpe.task_id = t.task_id and

Line 3659: l_top_task_plan_level pa_fp_elements.top_task_planning_level%type;

3655: l_source_fp_opt_id NUMBER;
3656: l_target_fp_opt_id NUMBER;
3657: l_source_ver_type pa_budget_versions.version_type%type;
3658: l_target_ver_type pa_budget_versions.version_type%type;
3659: l_top_task_plan_level pa_fp_elements.top_task_planning_level%type;
3660: BEGIN
3661: l_count := 0;
3662: x_msg_count := 0;
3663: l_error_msg_header_flag := 'N';

Line 3819: from pa_fp_elements fpe

3815: c1_rec.task_id <> c1_rec.top_task_id then
3816: begin
3817: select nvl(fpe.top_task_planning_level,'LOWEST')
3818: into l_top_task_plan_level
3819: from pa_fp_elements fpe
3820: where
3821: fpe.proj_fp_options_id = l_target_fp_opt_id and
3822: fpe.element_type = l_target_ver_type and
3823: fpe.task_id = c1_rec.task_id and

Line 3834: from pa_fp_elements fpe

3830: target */
3831: begin
3832: select nvl(fpe.top_task_planning_level,'LOWEST')
3833: into l_top_task_plan_level
3834: from pa_fp_elements fpe
3835: where
3836: fpe.proj_fp_options_id = l_target_fp_opt_id and
3837: fpe.element_type = l_target_ver_type and
3838: fpe.task_id = c1_rec.top_task_id and

Line 3888: from pa_fp_elements

3884: ( p_s_fin_plan_level_code = 'T' and p_t_fin_plan_level_code = 'M' ) OR
3885: ( p_s_fin_plan_level_code = 'T' and p_t_fin_plan_level_code = 'T' ) then
3886: begin
3887: select resource_planning_level into l_target_plan_level
3888: from pa_fp_elements
3889: where proj_fp_options_id = l_target_fp_opt_id
3890: and element_type = l_target_ver_type
3891: and resource_list_member_id = 0
3892: and plannable_flag = 'Y'

Line 4030: pa_fp_elements fpe,

4026: seq_no,
4027: NVL(fpe.top_task_planning_level,'LOWEST')
4028: top_task_planning_level
4029: from
4030: pa_fp_elements fpe,
4031: pa_tasks t where
4032: fpe.proj_fp_options_id = c_fp_opt_id and
4033: fpe.element_type = c_ver_type and
4034: fpe.task_id = t.task_id and

Line 4055: l_top_task_plan_level pa_fp_elements.top_task_planning_level%type;

4051: l_source_fp_opt_id NUMBER;
4052: l_target_fp_opt_id NUMBER;
4053: l_source_ver_type pa_budget_versions.version_type%type;
4054: l_target_ver_type pa_budget_versions.version_type%type;
4055: l_top_task_plan_level pa_fp_elements.top_task_planning_level%type;
4056: l_source_task_id number;
4057: l_source_plan_level varchar2(30);
4058: l_target_plan_level varchar2(30);
4059: l_index number;

Line 4126: from pa_fp_elements fpe

4122: ,x_log_level => 5);
4123: END IF;
4124: select nvl(fpe.top_task_planning_level,'LOWEST')
4125: into l_top_task_plan_level
4126: from pa_fp_elements fpe
4127: where
4128: fpe.proj_fp_options_id = l_target_fp_opt_id and
4129: fpe.element_type = l_target_ver_type and
4130: fpe.task_id = tsk_rec.task_id and

Line 4148: from pa_fp_elements fpe

4144: ,x_log_level => 5);
4145: END IF;
4146: select nvl(fpe.top_task_planning_level,'LOWEST')
4147: into l_top_task_plan_level
4148: from pa_fp_elements fpe
4149: where
4150: fpe.proj_fp_options_id = l_target_fp_opt_id and
4151: fpe.element_type = l_target_ver_type and
4152: fpe.task_id = tsk_rec.top_task_id and

Line 4171: from pa_fp_elements fpe

4167: ,x_log_level => 5);
4168: END IF;
4169: select nvl(fpe.top_task_planning_level,'LOWEST')
4170: into l_top_task_plan_level
4171: from pa_fp_elements fpe
4172: where
4173: fpe.proj_fp_options_id = l_target_fp_opt_id and
4174: fpe.element_type = l_target_ver_type and
4175: fpe.task_id = tsk_rec.top_task_id and