APPS.PJI_RM_SUM_AVL dependencies on FII_TIME_DAY

Line 103: --Get the minimum of julian start day from fii_time_day

99: INTO g_no_of_user_def_threshold
100: FROM PJI_MT_BUCKETS
101: WHERE BUCKET_SET_CODE = 'PJI_RESOURCE_AVAILABILITY';
102:
103: --Get the minimum of julian start day from fii_time_day
104: SELECT MIN(to_char(fiik.start_date,'j'))
105: INTO g_min_wk_j_st_date
106: FROM fii_time_week fiik;
107:

Line 1449: and join it to FII_TIME_DAY to get appropriate distinct records

1445: The idea is to determine all different periods and quarters for
1446: both enterprise and GL periods that are affected by the
1447: incremental change in the availability data.
1448: So, for Enterprise periods, we select from PJI_RM_AGGR_RES2
1449: and join it to FII_TIME_DAY to get appropriate distinct records
1450: for the periods/quarters/weeks affected. Similarly, for GL periods,
1451: we select from PJI_RM_AGGR_RES2 and join it to
1452: FII_TIME_CAL_DAY_MV and PJI_ORG_EXTR_INFO to get appropriate
1453: distinct records for the periods/quarters affected.

Line 1524: FII_TIME_DAY fiit

1520: fiit.ent_qtr_id as qtr_id,
1521: (to_char(fiit.week_start_date,'j') - g_min_wk_j_st_date)/7 + 1 as week_id
1522: FROM
1523: PJI_RM_AGGR_RES2 tmp2,
1524: FII_TIME_DAY fiit
1525: WHERE
1526: tmp2.person_id = p_person_id
1527: and tmp2.time_id = fiit.report_date_julian
1528: and (

Line 1737: FII_TIME_DAY fiit

1733: 0 as ROLL_X_WEEK_12,
1734: 0 as ROLL_X_WEEK_13
1735: FROM
1736: PJI_RM_AGGR_AVL1 avl_tmp1,
1737: FII_TIME_DAY fiit
1738: WHERE
1739: avl_tmp1.PERIOD_ID = fiit.ENT_QTR_ID
1740: and avl_tmp1.period_type_id = 64
1741: and avl_tmp1.period_type = 'E'

Line 1895: , FII_TIME_DAY fiid

1891: WHERE
1892: cur4.period_id = fweek.sequence_id
1893: and cur4.week_id = fweek1.sequence_id (+)
1894: ) cur
1895: , FII_TIME_DAY fiid
1896: WHERE
1897: cur.PERIOD_ID = fiid.WEEK_ID
1898: ) cur1
1899: GROUP BY