DBA Data[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on PJI_TIME_ENT_PERIOD_V

Line 2421: pji_time_ent_period_V

2417: ,0 itd_mask
2418: ,0 ac_mask
2419: ,1 prp_mask
2420: FROM
2421: pji_time_ent_period_V
2422: WHERE 1=1
2423: AND TO_DATE(pPeriodDateJulian,l_julianFormat)-1 BETWEEN start_date AND end_date
2424: AND pCalendarType = l_calendarType_E
2425: ) TIME

Line 3073: pji_time_ent_period_V

3069: ,0 itd_mask
3070: ,0 ac_mask
3071: ,1 prp_mask
3072: FROM
3073: pji_time_ent_period_V
3074: WHERE 1=1
3075: AND TO_DATE(pPeriodDateJulian,l_julianFormat)-1 BETWEEN start_date AND end_date -- report_date
3076: AND pCalendarType = l_calendarType_E
3077: ) TIME

Line 3210: FROM pji_time_ent_period_v

3206: xDaysSinceITD
3207: , l_org_id
3208: FROM pa_projects_all,
3209: ( SELECT end_date
3210: FROM pji_time_ent_period_v
3211: WHERE 1=1
3212: AND TO_DATE(pPeriodDateJulian,'j') BETWEEN start_date AND end_date
3213: AND pCalendarType = 'E'
3214: UNION ALL

Line 3239: FROM pji_time_ent_period_v

3235: SELECT days
3236: INTO xDaysInPeriod
3237: FROM (
3238: SELECT (end_date - start_date+1) days
3239: FROM pji_time_ent_period_v
3240: WHERE 1=1
3241: AND TO_DATE(pPeriodDateJulian,'j') BETWEEN start_date AND end_date
3242: AND pCalendarType = 'E'
3243: UNION ALL