APPS.PJI_FM_PLAN_CAL_RLPS dependencies on PJI_ORG_EXTR_INFO

Line 4012: -- , pji_org_extr_info orginfo

4008: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
4009: , g_default_prg_level PRG_LEVEL
4010: FROM pji_fp_aggr_pjp1 fact
4011: , pji_time_cal_period non_pa_cal
4012: -- , pji_org_extr_info orginfo
4013: , pji_time_ent_period pa_cal
4014: , pji_fm_extr_plnver4 ver
4015: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4016: AND fact.worker_id = g_worker_id

Line 4735: , pji_org_extr_info orginfo

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

Line 5069: , pji_org_extr_info orginfo

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

Line 5296: , pji_org_extr_info orginfo

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

Line 5524: , pji_org_extr_info orginfo

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