APPS.PJI_FM_PLAN_EXTR dependencies on FII_TIME_CAL_PERIOD

Line 254: from fii_time_cal_period cal_pa

250: , to_number(to_char(cal_pa.start_date,'J'))
251: , to_number(to_char(cal_pa.end_date,'J'))
252: , nvl( curr.minimum_accountable_unit
253: , power( 10, (-1 * curr.precision)))
254: from fii_time_cal_period cal_pa
255: , fnd_currencies curr
256: where cal_pa.calendar_id = orginfo.pa_calendar_id
257: and DECODE(sign(g_global_start_J - orginfo.pa_calendar_min_date)
258: , 1, g_global_start_date

Line 278: from fii_time_cal_period cal_gl

274: cal_gl.cal_period_id
275: , cal_gl.name
276: , to_number(to_char(cal_gl.start_date,'J'))
277: , to_number(to_char(cal_gl.end_date,'J'))
278: from fii_time_cal_period cal_gl
279: where cal_gl.calendar_id = orginfo.gl_calendar_id
280: and DECODE(sign(g_global_start_J - orginfo.gl_calendar_min_date)
281: , 1, g_global_start_date
282: , to_char(to_date(orginfo.gl_calendar_min_date,'J'),'DD-MON-YYYY')

Line 643: from fii_time_cal_period

639: , cal_period_id period_id
640: , name period_name
641: , start_date start_date
642: , end_date end_date
643: from fii_time_cal_period
644: ) fii_time
645: where 1=1
646: and orginfo.projfunc_currency_mau is not null
647: and vers.worker_id = p_worker_id

Line 1357: , fii_time_cal_period cal_pa

1353: , tmp.rate2_dangling_flag rate2_dangling_flag
1354: from
1355: PJI_ORG_EXTR_INFO orginfo
1356: , PJI_FM_EXTR_PLAN tmp
1357: , fii_time_cal_period cal_pa
1358: where tmp.worker_id = p_worker_id
1359: and tmp.end_date >= cal_pa.start_date
1360: and tmp.start_date <= cal_pa.end_date
1361: and tmp.calendar_type_code <> 'PA'

Line 1529: , fii_time_cal_period cal_gl

1525: , tmp.rate2_dangling_flag rate2_dangling_flag
1526: from
1527: PJI_ORG_EXTR_INFO orginfo
1528: , PJI_FM_EXTR_PLAN tmp
1529: , fii_time_cal_period cal_gl
1530: where tmp.worker_id = p_worker_id
1531: and tmp.end_date >= cal_gl.start_date
1532: and tmp.start_date <= cal_gl.end_date
1533: and tmp.calendar_type_code <> 'GL'