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 4575: , pji_time_cal_period_v non_pa_cal

4571: Greatest(non_pa_cal.start_date,pa_cal.start_date)+1)
4572: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
4573: , fact.plan_type_code plan_type_code /* 4471527 */
4574: FROM pji_fp_aggr_pjp1_t fact
4575: , pji_time_cal_period_v non_pa_cal
4576: , pji_time_ent_period_v pa_cal
4577: , pji_fm_extr_plnver3_t ver
4578: , (SELECT currency_code,
4579: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),

Line 7583: , pji_time_cal_period_v non_pa_cal

7579: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7580: , g_default_prg_level prg_level
7581: , fact.plan_type_code plan_type_code /* 4471527 */
7582: FROM pji_fp_aggr_pjp1_t fact
7583: , pji_time_cal_period_v non_pa_cal
7584: , pji_time_ent_period_v pa_cal
7585: , pji_fm_extr_plnver3_t ver
7586: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7587: AND fact.worker_id = g_worker_id

Line 9649: pji_time_cal_period_v pri

9645: pri.cal_period_id pri_cal_period_id,
9646: sec.cal_period_id sec_cal_period_id,
9647: orginfo.org_id
9648: FROM
9649: pji_time_cal_period_v pri
9650: , pji_org_extr_info orginfo
9651: , pji_time_cal_period_v sec
9652: , pji_fm_extr_plnver3_t ver
9653: , pa_projects_all ppa

Line 9651: , pji_time_cal_period_v sec

9647: orginfo.org_id
9648: FROM
9649: pji_time_cal_period_v pri
9650: , pji_org_extr_info orginfo
9651: , pji_time_cal_period_v sec
9652: , pji_fm_extr_plnver3_t ver
9653: , pa_projects_all ppa
9654: WHERE 1=1
9655: AND ppa.org_id=orginfo.org_id

Line 12274: , pji_time_cal_period_v pa_cal

12270: / (fact.end_date - fact.start_date+1) factor
12271: , fact.plan_type_code plan_type_code /* 4471527 */
12272: FROM pji_fp_aggr_pjp1_t fact
12273: , pji_org_extr_info orginfo
12274: , pji_time_cal_period_v pa_cal
12275: , pji_fm_extr_plnver3_t ver
12276: ,(SELECT currency_code,
12277: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
12278: null, 0.01,

Line 12697: , pji_time_cal_period_v non_pa_cal

12693: , NULL RATE_DANGLING_FLAG
12694: , g_default_prg_level prg_level
12695: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODe /* 4471527 */
12696: FROM pji_fp_aggr_pjp1_t fact
12697: , pji_time_cal_period_v non_pa_cal
12698: , pji_org_extr_info orginfo
12699: , pji_time_cal_period_v pa_cal
12700: , pji_fm_extr_plnver3_t ver
12701: WHERE fact.CALENDAR_TYPE <> p_calendar_type

Line 12699: , pji_time_cal_period_v pa_cal

12695: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODe /* 4471527 */
12696: FROM pji_fp_aggr_pjp1_t fact
12697: , pji_time_cal_period_v non_pa_cal
12698: , pji_org_extr_info orginfo
12699: , pji_time_cal_period_v pa_cal
12700: , pji_fm_extr_plnver3_t ver
12701: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12702: AND fact.worker_id = g_worker_id
12703: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 13343: , pji_time_cal_period_v pa_cal

13339: , g_default_prg_level prg_level
13340: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
13341: FROM pji_fp_aggr_pjp1_t fact
13342: , pji_org_extr_info orginfo
13343: , pji_time_cal_period_v pa_cal
13344: , pji_fm_extr_plnver3_t ver
13345: WHERE 1=1
13346: AND fact.CALENDAR_TYPE = 'A'
13347: AND orginfo.org_id = fact.PROJECT_ORG_ID