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 5589: -- , pji_org_extr_info orginfo

5585: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
5586: , fact.plan_type_code plan_type_code /* 4471527 */
5587: FROM pji_fp_xbs_accum_f fact
5588: , pji_time_cal_period non_pa_cal
5589: -- , pji_org_extr_info orginfo
5590: , pji_time_ent_period pa_cal
5591: , PJI_FM_EXTR_PLNVER3_T ver
5592: WHERE 1 = 1
5593: AND fact.calendar_type IN ('P', 'G')

Line 7252: -- , pji_org_extr_info orginfo

7248: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7249: , g_default_prg_level prg_level
7250: FROM pji_fp_aggr_pjp1_t fact
7251: , pji_time_cal_period non_pa_cal
7252: -- , pji_org_extr_info orginfo
7253: , pji_time_ent_period pa_cal
7254: , pji_fm_extr_plnver3_t ver
7255: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7256: AND fact.worker_id = g_worker_id

Line 7656: -- , pji_org_extr_info orginfo

7652: , fact.plan_type_code plan_type_code /* 4471527 */
7653: FROM pji_fp_xbs_accum_f fact
7654: , PJI_FM_EXTR_PLNVER3_T ver
7655: , pji_time_cal_period non_pa_cal
7656: -- , pji_org_extr_info orginfo
7657: , pji_time_ent_period pa_cal
7658: WHERE non_pa_cal.cal_period_id = fact.time_id
7659: AND fact.period_type_id = 32
7660: AND ver.project_id = fact.project_id

Line 9221: , pji_org_extr_info orginfo

9217: , fact.time_dangling_flag time_dangling_flag
9218: , fact.rate_dangling_flag rate_dangling_flag
9219: FROM pji_fp_aggr_pjp1_t fact
9220: , pji_time_cal_period non_pa_cal
9221: , pji_org_extr_info orginfo
9222: , pji_time_cal_period pa_cal
9223: , pji_fm_extr_plnver3_t ver
9224: WHERE 1=1
9225: AND fact.CALENDAR_TYPE <> p_calendar_type

Line 9512: , pji_org_extr_info orginfo

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

Line 10689: , pji_org_extr_info orginfo

10685: ,fact.plan_type_code plan_type_code /*4471527 */
10686: FROM pji_fp_xbs_accum_f fact
10687: , PJI_FM_EXTR_PLNVER3_T ver
10688: , pji_time_cal_period non_pa_cal
10689: , pji_org_extr_info orginfo
10690: , pji_time_cal_period pa_cal
10691: WHERE 1=1
10692: AND fact.CALENDAR_TYPE <> p_calendar_type
10693: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 11844: , pji_org_extr_info orginfo

11840: , 'CF' line_type
11841: , NULL time_dangling_flag
11842: , NULL rate_dangling_flag
11843: FROM pji_fp_aggr_pjp1_t fact
11844: , pji_org_extr_info orginfo
11845: , pji_time_cal_period pa_cal
11846: , pji_fm_extr_plnver3_t ver
11847: WHERE 1=1
11848: AND fact.CALENDAR_TYPE = 'A'

Line 12135: , pji_org_extr_info orginfo

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

Line 12365: , pji_org_extr_info orginfo

12361: , NULL RATE_DANGLING_FLAG
12362: , g_default_prg_level prg_level
12363: FROM pji_fp_aggr_pjp1_t fact
12364: , pji_time_cal_period non_pa_cal
12365: , pji_org_extr_info orginfo
12366: , pji_time_cal_period pa_cal
12367: , pji_fm_extr_plnver3_t ver
12368: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12369: AND fact.worker_id = g_worker_id

Line 12560: , pji_org_extr_info orginfo

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

Line 12776: , pji_org_extr_info orginfo

12772: , fact.plan_type_code plan_type_code /* 4471527 */
12773: FROM pji_fp_xbs_accum_f fact
12774: , PJI_FM_EXTR_PLNVER3_T ver
12775: , pji_time_cal_period non_pa_cal
12776: , pji_org_extr_info orginfo
12777: , pji_time_cal_period pa_cal
12778: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12779: AND fact.CALENDAR_TYPE IN ('P', 'G')
12780: AND non_pa_cal.cal_period_id = fact.time_id

Line 12992: , pji_org_extr_info orginfo

12988: , NULL TIME_DANGLING_FLAG
12989: , NULL RATE_DANGLING_FLAG
12990: , g_default_prg_level prg_level
12991: FROM pji_fp_aggr_pjp1_t fact
12992: , pji_org_extr_info orginfo
12993: , pji_time_cal_period pa_cal
12994: , pji_fm_extr_plnver3_t ver
12995: WHERE 1=1
12996: AND fact.CALENDAR_TYPE = 'A'

Line 13204: , pji_org_extr_info orginfo

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