DBA Data[Home] [Help]

APPS.JTF_CAL_PVT dependencies on JTF_CAL_ITEMS_B

Line 479: FROM jtf_cal_items_b jtb

475: , jtb.end_date EndDate
476: , jtb.timezone_id TimezoneID
477: , jtb.url URL
478: , jtf_cal_items_pvt.GetUrlParams(jtb.SOURCE_CODE, jtb.SOURCE_ID) URLParams
479: FROM jtf_cal_items_b jtb
480: WHERE( jtb.start_date <= b_EndDate
481: )
482: AND ( jtb.end_date >= b_StartDate
483: )

Line 505: FROM jtf_cal_items_b jtb

501: , jtb.end_date EndDate
502: , jtb.timezone_id TimezoneID
503: , jtb.url URL
504: , jtf_cal_items_pvt.GetUrlParams(jtb.SOURCE_CODE, jtb.SOURCE_ID) URLParams
505: FROM jtf_cal_items_b jtb
506: WHERE jtb.resource_id = b_ResourceID
507: AND jtb.resource_type = 'RS_EMPLOYEE'
508: AND ( jtb.start_date <= b_EndDate
509: )