APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_PROJECTS_ALL

Line 316: FROM pa_projects_all

312: print_time ( ' get_summarized_data 0002 ' ) ;
313:
314: SELECT ORG_ID
315: INTO l_org_id
316: FROM pa_projects_all
317: WHERE project_id = p_project_id;
318:
319: IF l_calendar_type ='A' then
320: l_end_period_id :=-1;

Line 482: FROM pa_projects_all

478:
479: --Get org for the project
480: SELECT ORG_ID
481: INTO l_org_id(i)
482: FROM pa_projects_all
483: WHERE project_id = p_project_ids(i);
484: print_time ( ' get_summarized_data 0004.1 ' || l_org_id(i) || ' l_calendar_type ' || l_calendar_type(i) ) ;
485:
486: -------------------------------

Line 1724: FROM pa_projects_all

1720:
1721: BEGIN
1722: SELECT ORG_ID
1723: INTO l_org_id
1724: FROM pa_projects_all
1725: WHERE project_id = p_project_id ;
1726:
1727: IF L_CAL_TYPE IN ('P', 'G') THEN -- retrieve CAL_PERIOD_ID only if calander_type is 'P' or 'G'
1728: SELECT cal.CAL_PERIOD_ID

Line 2488: pa_projects_all pa

2484: SELECT DECODE(NVL(NVL(fp.cost_time_phased_code, fp.revenue_time_phased_code ), fp.all_time_phased_code), 'G', 'G', 'P', 'P', 'A') calendar_type,
2485: pa.ORG_ID
2486: FROM
2487: pa_proj_fp_options fp,
2488: pa_projects_all pa
2489: WHERE 1=1
2490: and pa.project_id=fp.project_id
2491: and pa.project_id=tmp.project_id
2492: and fp.fin_plan_option_level_code = 'PLAN_VERSION'

Line 3333: PA_PROJECTS_ALL prj,

3329: 'INDIRECT', 'I'),
3330: prj.PROJECT_CURRENCY_CODE,
3331: null
3332: from
3333: PA_PROJECTS_ALL prj,
3334: PA_PROJECT_TYPES_ALL pt
3335: where
3336: -- We cannot depend on extraction start date as it will not be
3337: -- set at the time of upgrade.