APPS.PA_SCHEDULE_PVT dependencies on JTF_CAL_RESOURCE_ASSIGN

Line 1141: FROM jtf_cal_resource_assign jtf_res

1137: -- condition so that calendar_id, resource_id index would be used.
1138:
1139: CURSOR C1 IS SELECT calendar_id,trunc(start_date_time) start_date,
1140: NVL(trunc(end_date_time),TO_DATE('01/01/2050','MM/DD/YYYY')) end_date
1141: FROM jtf_cal_resource_assign jtf_res
1142: WHERE jtf_res.resource_id = l_t_resource_id
1143: AND jtf_res.primary_calendar_flag = 'Y'
1144: AND jtf_res.calendar_id > 0
1145: AND jtf_res.resource_type_code = 'RS_EMPLOYEE'

Line 1250: -- calendar instead of going to the jtf_cal_resource_assign table.

1246: PA_SCHEDULE_UTILS.log_message(1,'status ... '||l_x_return_status);
1247:
1248: -- 1965289: Work around for CRM bug (cannot create future dated resources).
1249: -- If the jtf_resource_id is null, then we need to use the default
1250: -- calendar instead of going to the jtf_cal_resource_assign table.
1251:
1252: -- Start 1965289 bugfix.
1253: IF (l_t_resource_id is null) THEN
1254: -- Find the start date for the first HR assignment.

Line 1446: FROM jtf_cal_resource_assign

1442: -- condition so that calendar_id, resource_id index would be used.
1443:
1444: SELECT MIN(start_date_time),MAX(NVL(end_date_time,TO_DATE('01/01/2050','MM/DD/YYYY')))
1445: INTO l_temp_start_date,l_temp_end_date
1446: FROM jtf_cal_resource_assign
1447: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id
1448: AND jtf_cal_resource_assign.calendar_id > 0
1449: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
1450: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';

Line 1447: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id

1443:
1444: SELECT MIN(start_date_time),MAX(NVL(end_date_time,TO_DATE('01/01/2050','MM/DD/YYYY')))
1445: INTO l_temp_start_date,l_temp_end_date
1446: FROM jtf_cal_resource_assign
1447: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id
1448: AND jtf_cal_resource_assign.calendar_id > 0
1449: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
1450: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
1451: END IF;

Line 1448: AND jtf_cal_resource_assign.calendar_id > 0

1444: SELECT MIN(start_date_time),MAX(NVL(end_date_time,TO_DATE('01/01/2050','MM/DD/YYYY')))
1445: INTO l_temp_start_date,l_temp_end_date
1446: FROM jtf_cal_resource_assign
1447: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id
1448: AND jtf_cal_resource_assign.calendar_id > 0
1449: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
1450: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
1451: END IF;
1452:

Line 1449: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'

1445: INTO l_temp_start_date,l_temp_end_date
1446: FROM jtf_cal_resource_assign
1447: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id
1448: AND jtf_cal_resource_assign.calendar_id > 0
1449: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
1450: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
1451: END IF;
1452:
1453: PA_SCHEDULE_UTILS.log_message(1,'Start date ... '||to_char(l_temp_start_date)||to_char(p_start_date));

Line 1450: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';

1446: FROM jtf_cal_resource_assign
1447: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id
1448: AND jtf_cal_resource_assign.calendar_id > 0
1449: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
1450: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
1451: END IF;
1452:
1453: PA_SCHEDULE_UTILS.log_message(1,'Start date ... '||to_char(l_temp_start_date)||to_char(p_start_date));
1454: PA_SCHEDULE_UTILS.log_message(1,'end date ... '||to_char(l_temp_end_date)||to_char(p_end_date));