DBA Data[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on PJI_TIME_CAL_RPT_STRUCT

Line 2366: PJI_TIME_CAL_RPT_STRUCT

2362: ,SIGN(bitand(record_type_id,g_itd_record_type)) itd_mask
2363: ,0 ac_mask
2364: ,0 prp_mask
2365: FROM
2366: PJI_TIME_CAL_RPT_STRUCT
2367: WHERE 1=1
2368: AND bitand(record_type_id,pTimeSlice) = record_type_id --the records above the selected slice are excluded
2369: AND calendar_id = pCalendarId
2370: AND report_date = TO_DATE(pPeriodDateJulian,l_julianFormat)

Line 3019: PJI_TIME_CAL_RPT_STRUCT

3015: ,SIGN(bitand(record_type_id,g_itd_record_type)) itd_mask
3016: ,0 ac_mask
3017: ,0 prp_mask
3018: FROM
3019: PJI_TIME_CAL_RPT_STRUCT
3020: WHERE 1=1
3021: AND bitand(record_type_id,pTimeSlice) = record_type_id
3022: AND calendar_id = pCalendarId
3023: AND report_date = TO_DATE(pPeriodDateJulian,l_julianFormat)