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_T dependencies on PJI_TIME_CAL_PERIOD_V

Line 4437: , pji_time_cal_period_v non_pa_cal

4433: Greatest(non_pa_cal.start_date,pa_cal.start_date)+1)
4434: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
4435: , fact.plan_type_code plan_type_code /* 4471527 */
4436: FROM pji_fp_aggr_pjp1_t fact
4437: , pji_time_cal_period_v non_pa_cal
4438: , pji_time_ent_period_v pa_cal
4439: , pji_fm_extr_plnver3_t ver
4440: , (SELECT currency_code,
4441: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),

Line 7445: , pji_time_cal_period_v non_pa_cal

7441: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7442: , g_default_prg_level prg_level
7443: , fact.plan_type_code plan_type_code /* 4471527 */
7444: FROM pji_fp_aggr_pjp1_t fact
7445: , pji_time_cal_period_v non_pa_cal
7446: , pji_time_ent_period_v pa_cal
7447: , pji_fm_extr_plnver3_t ver
7448: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7449: AND fact.worker_id = g_worker_id

Line 9511: pji_time_cal_period_v pri

9507: pri.cal_period_id pri_cal_period_id,
9508: sec.cal_period_id sec_cal_period_id,
9509: orginfo.org_id
9510: FROM
9511: pji_time_cal_period_v pri
9512: , pji_org_extr_info orginfo
9513: , pji_time_cal_period_v sec
9514: , pji_fm_extr_plnver3_t ver
9515: , pa_projects_all ppa

Line 9513: , pji_time_cal_period_v sec

9509: orginfo.org_id
9510: FROM
9511: pji_time_cal_period_v pri
9512: , pji_org_extr_info orginfo
9513: , pji_time_cal_period_v sec
9514: , pji_fm_extr_plnver3_t ver
9515: , pa_projects_all ppa
9516: WHERE 1=1
9517: AND ppa.org_id=orginfo.org_id

Line 12136: , pji_time_cal_period_v pa_cal

12132: / (fact.end_date - fact.start_date+1) factor
12133: , fact.plan_type_code plan_type_code /* 4471527 */
12134: FROM pji_fp_aggr_pjp1_t fact
12135: , pji_org_extr_info orginfo
12136: , pji_time_cal_period_v pa_cal
12137: , pji_fm_extr_plnver3_t ver
12138: ,(SELECT currency_code,
12139: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
12140: null, 0.01,

Line 12559: , pji_time_cal_period_v non_pa_cal

12555: , NULL RATE_DANGLING_FLAG
12556: , g_default_prg_level prg_level
12557: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODe /* 4471527 */
12558: FROM pji_fp_aggr_pjp1_t fact
12559: , pji_time_cal_period_v non_pa_cal
12560: , pji_org_extr_info orginfo
12561: , pji_time_cal_period_v pa_cal
12562: , pji_fm_extr_plnver3_t ver
12563: WHERE fact.CALENDAR_TYPE <> p_calendar_type

Line 12561: , pji_time_cal_period_v pa_cal

12557: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODe /* 4471527 */
12558: FROM pji_fp_aggr_pjp1_t fact
12559: , pji_time_cal_period_v non_pa_cal
12560: , pji_org_extr_info orginfo
12561: , pji_time_cal_period_v pa_cal
12562: , pji_fm_extr_plnver3_t ver
12563: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12564: AND fact.worker_id = g_worker_id
12565: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 13205: , pji_time_cal_period_v pa_cal

13201: , g_default_prg_level prg_level
13202: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
13203: FROM pji_fp_aggr_pjp1_t fact
13204: , pji_org_extr_info orginfo
13205: , pji_time_cal_period_v pa_cal
13206: , pji_fm_extr_plnver3_t ver
13207: WHERE 1=1
13208: AND fact.CALENDAR_TYPE = 'A'
13209: AND orginfo.org_id = fact.PROJECT_ORG_ID