eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_PLAN_CAL_RLPS dependencies on PJI_TIME_CAL_PERIOD_V

Line 3466: , pji_time_cal_period_v non_pa_cal

3462: Greatest(non_pa_cal.start_date,pa_cal.start_date)+1)
3463: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
3464: , fact.plan_type_code plan_type_code /* 4471527 */
3465: FROM pji_fp_aggr_pjp1 fact
3466: , pji_time_cal_period_v non_pa_cal
3467: , pji_time_ent_period_v pa_cal
3468: , pji_fm_extr_plnver4 ver
3469: , (SELECT currency_code,
3470: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),

Line 4206: , pji_time_cal_period_v non_pa_cal

4202: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
4203: , g_default_prg_level prg_level
4204: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
4205: FROM pji_fp_aggr_pjp1 fact
4206: , pji_time_cal_period_v non_pa_cal
4207: , pji_time_ent_period_v pa_cal
4208: , pji_fm_extr_plnver4 ver
4209: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4210: AND fact.worker_id = g_worker_id

Line 4734: pji_time_cal_period_v pri

4730: pri.cal_period_id pri_cal_period_id,
4731: sec.cal_period_id sec_cal_period_id,
4732: orginfo.org_id
4733: FROM
4734: pji_time_cal_period_v pri
4735: , pji_org_extr_info orginfo
4736: , pji_time_cal_period_v sec
4737: , pji_fm_extr_plnver4 ver
4738: , pa_projects_all ppa

Line 4736: , pji_time_cal_period_v sec

4732: orginfo.org_id
4733: FROM
4734: pji_time_cal_period_v pri
4735: , pji_org_extr_info orginfo
4736: , pji_time_cal_period_v sec
4737: , pji_fm_extr_plnver4 ver
4738: , pa_projects_all ppa
4739: WHERE 1=1
4740: AND ppa.org_id=orginfo.org_id

Line 5070: , pji_time_cal_period_v pa_cal

5066: / (fact.end_date - fact.start_date+1) factor
5067: , fact.plan_type_code plan_type_code /* 4471527 */
5068: FROM pji_fp_aggr_pjp1 fact
5069: , pji_org_extr_info orginfo
5070: , pji_time_cal_period_v pa_cal
5071: , pji_fm_extr_plnver4 ver
5072: ,(SELECT currency_code,
5073: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
5074: null, 0.01,

Line 5295: , pji_time_cal_period_v non_pa_cal

5291: , NULL RATE_DANGLING_FLAG
5292: , g_default_prg_level prg_level
5293: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
5294: FROM pji_fp_aggr_pjp1 fact
5295: , pji_time_cal_period_v non_pa_cal
5296: , pji_org_extr_info orginfo
5297: , pji_time_cal_period_v pa_cal
5298: , pji_fm_extr_plnver4 ver
5299: WHERE fact.CALENDAR_TYPE <> p_calendar_type

Line 5297: , pji_time_cal_period_v pa_cal

5293: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
5294: FROM pji_fp_aggr_pjp1 fact
5295: , pji_time_cal_period_v non_pa_cal
5296: , pji_org_extr_info orginfo
5297: , pji_time_cal_period_v pa_cal
5298: , pji_fm_extr_plnver4 ver
5299: WHERE fact.CALENDAR_TYPE <> p_calendar_type
5300: AND fact.worker_id = g_worker_id
5301: AND ver.worker_id = g_worker_id

Line 5525: , pji_time_cal_period_v pa_cal

5521: , g_default_prg_level prg_level
5522: , fact.plan_type_code PLAN_TYPE_CODE /* 4471527 */
5523: FROM pji_fp_aggr_pjp1 fact
5524: , pji_org_extr_info orginfo
5525: , pji_time_cal_period_v pa_cal
5526: , pji_fm_extr_plnver4 ver
5527: WHERE 1=1
5528: AND fact.CALENDAR_TYPE = 'A'
5529: AND orginfo.org_id = fact.PROJECT_ORG_ID