APPS.PJI_FM_PLAN_CAL_RLPS dependencies on PJI_TIME_CAL_PERIOD_V

Line 3219: , pji_time_cal_period_v non_pa_cal

3215: Greatest(non_pa_cal.start_date,pa_cal.start_date)+1)
3216: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
3217: , fact.plan_type_code plan_type_code /* 4471527 */
3218: FROM pji_fp_aggr_pjp1 fact
3219: , pji_time_cal_period_v non_pa_cal
3220: , pji_time_ent_period_v pa_cal
3221: , pji_fm_extr_plnver4 ver
3222: , (SELECT currency_code,
3223: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),

Line 3948: , pji_time_cal_period_v non_pa_cal

3944: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
3945: , g_default_prg_level prg_level
3946: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
3947: FROM pji_fp_aggr_pjp1 fact
3948: , pji_time_cal_period_v non_pa_cal
3949: , pji_time_ent_period_v pa_cal
3950: , pji_fm_extr_plnver4 ver
3951: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
3952: AND fact.worker_id = g_worker_id

Line 4469: pji_time_cal_period_v pri

4465: pri.cal_period_id pri_cal_period_id,
4466: sec.cal_period_id sec_cal_period_id,
4467: orginfo.org_id
4468: FROM
4469: pji_time_cal_period_v pri
4470: , pji_org_extr_info orginfo
4471: , pji_time_cal_period_v sec
4472: , pji_fm_extr_plnver4 ver
4473: , pa_projects_all ppa

Line 4471: , pji_time_cal_period_v sec

4467: orginfo.org_id
4468: FROM
4469: pji_time_cal_period_v pri
4470: , pji_org_extr_info orginfo
4471: , pji_time_cal_period_v sec
4472: , pji_fm_extr_plnver4 ver
4473: , pa_projects_all ppa
4474: WHERE 1=1
4475: AND ppa.org_id=orginfo.org_id

Line 4797: , pji_time_cal_period_v pa_cal

4793: / (fact.end_date - fact.start_date+1) factor
4794: , fact.plan_type_code plan_type_code /* 4471527 */
4795: FROM pji_fp_aggr_pjp1 fact
4796: , pji_org_extr_info orginfo
4797: , pji_time_cal_period_v pa_cal
4798: , pji_fm_extr_plnver4 ver
4799: ,(SELECT currency_code,
4800: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4801: null, 0.01,

Line 5022: , pji_time_cal_period_v non_pa_cal

5018: , NULL RATE_DANGLING_FLAG
5019: , g_default_prg_level prg_level
5020: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
5021: FROM pji_fp_aggr_pjp1 fact
5022: , pji_time_cal_period_v non_pa_cal
5023: , pji_org_extr_info orginfo
5024: , pji_time_cal_period_v pa_cal
5025: , pji_fm_extr_plnver4 ver
5026: WHERE fact.CALENDAR_TYPE <> p_calendar_type

Line 5024: , pji_time_cal_period_v pa_cal

5020: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
5021: FROM pji_fp_aggr_pjp1 fact
5022: , pji_time_cal_period_v non_pa_cal
5023: , pji_org_extr_info orginfo
5024: , pji_time_cal_period_v pa_cal
5025: , pji_fm_extr_plnver4 ver
5026: WHERE fact.CALENDAR_TYPE <> p_calendar_type
5027: AND fact.worker_id = g_worker_id
5028: AND ver.worker_id = g_worker_id

Line 5249: , pji_time_cal_period_v pa_cal

5245: , g_default_prg_level prg_level
5246: , fact.plan_type_code PLAN_TYPE_CODE /* 4471527 */
5247: FROM pji_fp_aggr_pjp1 fact
5248: , pji_org_extr_info orginfo
5249: , pji_time_cal_period_v pa_cal
5250: , pji_fm_extr_plnver4 ver
5251: WHERE 1=1
5252: AND fact.CALENDAR_TYPE = 'A'
5253: AND orginfo.org_id = fact.PROJECT_ORG_ID