DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on JTF_CAL_ITEMS_B

Line 1234: FROM jtf_cal_items_b jtb

1230: , jtb.source_id SourceID
1231: , jtb.start_date StartDate
1232: , jtb.end_date EndDate
1233: , jtb.timezone_id TimezoneID
1234: FROM jtf_cal_items_b jtb
1235: WHERE( jtb.start_date <= b_EndDate
1236: )
1237: AND ( jtb.end_date >= b_StartDate
1238: )

Line 1257: FROM jtf_cal_items_b jtb

1253: , jtb.source_id SourceID
1254: , jtb.start_date StartDate
1255: , jtb.end_date EndDate
1256: , jtb.timezone_id TimezoneID
1257: FROM jtf_cal_items_b jtb
1258: WHERE jtb.resource_id = b_ResourceID
1259: AND jtb.resource_type = 'RS_EMPLOYEE'
1260: AND ( jtb.start_date <= b_EndDate
1261: )