APPS.PJI_REP_UTIL dependencies on PJI_FP_XBS_ACCUM_F

Line 1046: FROM pji_fp_xbs_accum_f WHERE project_id = p_project_id

1042: if(l_tp_flag = 'N') then
1043: x_calendar_type := NVL(Fnd_Profile.value('PJI_DEF_RPT_CAL_TYPE'), 'E');
1044: else
1045: SELECT Min(calendar_type) into x_calendar_type
1046: FROM pji_fp_xbs_accum_f WHERE project_id = p_project_id
1047: and plan_version_id <> -1 and calendar_type <> 'A';
1048: -- Bug 12708882 - if x_calendar_type is null, derive x_calendar_type as per original logic
1049: -- which was there before data processing control was implemented.
1050: -- x_calendar_type will be null for the case when the budgets are defined with time_phased_code

Line 3910: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE

3906: ( p_project_id IN pa_projects_all.project_id%TYPE
3907: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3908: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
3909: ,p_published_flag IN VARCHAR2
3910: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
3911: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
3912: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
3913: ,x_pc_flag OUT NOCOPY VARCHAR2
3914: ,x_pfc_flag OUT NOCOPY VARCHAR2

Line 4371: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE

4367: */
4368: PROCEDURE CHECK_WP_TIME_CONSISTENCY
4369: ( p_project_id IN pa_projects_all.project_id%TYPE
4370: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4371: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
4372: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
4373: ,x_time_phase_flag OUT NOCOPY VARCHAR2
4374: ,x_return_status OUT NOCOPY VARCHAR2
4375: ,x_msg_count OUT NOCOPY NUMBER

Line 4408: l_calendar_type pji_fp_xbs_accum_f.calendar_type%TYPE;

4404:
4405: l_module_name VARCHAR2(100) := 'pa.plsql.CHECK_WP_TIME_CONSISTENCY';
4406:
4407: l_calendar_id pa_projects_all.calendar_id%TYPE;
4408: l_calendar_type pji_fp_xbs_accum_f.calendar_type%TYPE;
4409:
4410: BEGIN
4411: x_msg_count := 0;
4412: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 6326: FROM pji_fp_xbs_accum_f f,

6322:
6323:
6324: SELECT Sum(brdn_cost) LATEST_PUBLISHED_COST
6325:
6326: FROM pji_fp_xbs_accum_f f,
6327: pa_projects_all p,
6328: pa_rbs_prj_assignments r,
6329: pa_proj_elem_ver_structure s,
6330: pa_proj_element_versions ppev,

Line 6382: pji_fp_xbs_accum_f f,

6378: CURSOR c1 IS
6379:
6380: SELECT Sum(f.brdn_cost) BASELINE_COST
6381: FROM
6382: pji_fp_xbs_accum_f f,
6383: pa_projects_all p,
6384: PA_PROJ_ELEM_VER_STRUCTURE ppev,
6385: pji_pjp_wbs_header h
6386: WHERE