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_ORG_EXTR_INFO

Line 5727: -- , pji_org_extr_info orginfo

5723: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
5724: , fact.plan_type_code plan_type_code /* 4471527 */
5725: FROM pji_fp_xbs_accum_f fact
5726: , pji_time_cal_period non_pa_cal
5727: -- , pji_org_extr_info orginfo
5728: , pji_time_ent_period pa_cal
5729: , PJI_FM_EXTR_PLNVER3_T ver
5730: WHERE 1 = 1
5731: AND fact.calendar_type IN ('P', 'G')

Line 7390: -- , pji_org_extr_info orginfo

7386: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7387: , g_default_prg_level prg_level
7388: FROM pji_fp_aggr_pjp1_t fact
7389: , pji_time_cal_period non_pa_cal
7390: -- , pji_org_extr_info orginfo
7391: , pji_time_ent_period pa_cal
7392: , pji_fm_extr_plnver3_t ver
7393: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7394: AND fact.worker_id = g_worker_id

Line 7794: -- , pji_org_extr_info orginfo

7790: , fact.plan_type_code plan_type_code /* 4471527 */
7791: FROM pji_fp_xbs_accum_f fact
7792: , PJI_FM_EXTR_PLNVER3_T ver
7793: , pji_time_cal_period non_pa_cal
7794: -- , pji_org_extr_info orginfo
7795: , pji_time_ent_period pa_cal
7796: WHERE non_pa_cal.cal_period_id = fact.time_id
7797: AND fact.period_type_id = 32
7798: AND ver.project_id = fact.project_id

Line 9359: , pji_org_extr_info orginfo

9355: , fact.time_dangling_flag time_dangling_flag
9356: , fact.rate_dangling_flag rate_dangling_flag
9357: FROM pji_fp_aggr_pjp1_t fact
9358: , pji_time_cal_period non_pa_cal
9359: , pji_org_extr_info orginfo
9360: , pji_time_cal_period pa_cal
9361: , pji_fm_extr_plnver3_t ver
9362: WHERE 1=1
9363: AND fact.CALENDAR_TYPE <> p_calendar_type

Line 9650: , pji_org_extr_info orginfo

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
9654: WHERE 1=1

Line 10827: , pji_org_extr_info orginfo

10823: ,fact.plan_type_code plan_type_code /*4471527 */
10824: FROM pji_fp_xbs_accum_f fact
10825: , PJI_FM_EXTR_PLNVER3_T ver
10826: , pji_time_cal_period non_pa_cal
10827: , pji_org_extr_info orginfo
10828: , pji_time_cal_period pa_cal
10829: WHERE 1=1
10830: AND fact.CALENDAR_TYPE <> p_calendar_type
10831: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 11982: , pji_org_extr_info orginfo

11978: , 'CF' line_type
11979: , NULL time_dangling_flag
11980: , NULL rate_dangling_flag
11981: FROM pji_fp_aggr_pjp1_t fact
11982: , pji_org_extr_info orginfo
11983: , pji_time_cal_period pa_cal
11984: , pji_fm_extr_plnver3_t ver
11985: WHERE 1=1
11986: AND fact.CALENDAR_TYPE = 'A'

Line 12273: , pji_org_extr_info orginfo

12269: , (LEAST(fact.end_date,pa_cal.end_date) - Greatest(fact.start_date,pa_cal.start_date)+1)
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))),

Line 12503: , pji_org_extr_info orginfo

12499: , NULL RATE_DANGLING_FLAG
12500: , g_default_prg_level prg_level
12501: FROM pji_fp_aggr_pjp1_t fact
12502: , pji_time_cal_period non_pa_cal
12503: , pji_org_extr_info orginfo
12504: , pji_time_cal_period pa_cal
12505: , pji_fm_extr_plnver3_t ver
12506: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12507: AND fact.worker_id = g_worker_id

Line 12698: , pji_org_extr_info orginfo

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
12702: AND fact.worker_id = g_worker_id

Line 12914: , pji_org_extr_info orginfo

12910: , fact.plan_type_code plan_type_code /* 4471527 */
12911: FROM pji_fp_xbs_accum_f fact
12912: , PJI_FM_EXTR_PLNVER3_T ver
12913: , pji_time_cal_period non_pa_cal
12914: , pji_org_extr_info orginfo
12915: , pji_time_cal_period pa_cal
12916: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12917: AND fact.CALENDAR_TYPE IN ('P', 'G')
12918: AND non_pa_cal.cal_period_id = fact.time_id

Line 13130: , pji_org_extr_info orginfo

13126: , NULL TIME_DANGLING_FLAG
13127: , NULL RATE_DANGLING_FLAG
13128: , g_default_prg_level prg_level
13129: FROM pji_fp_aggr_pjp1_t fact
13130: , pji_org_extr_info orginfo
13131: , pji_time_cal_period pa_cal
13132: , pji_fm_extr_plnver3_t ver
13133: WHERE 1=1
13134: AND fact.CALENDAR_TYPE = 'A'

Line 13342: , pji_org_extr_info orginfo

13338: , NULL RATE_DANGLING_FLAG
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'