APPS.PSP_ORG_DLS_PKG dependencies on PSP_REP_SCH_EMP_V

Line 1503: from PSP_REP_SCH_EMP_V

1499: -- First, ensure that all variables that have to be returned are set to NULL
1500: l_Period1_Start := NULL;
1501: l_Period1_End := NULL;
1502: Select MAX(SCHEDULE_END_DATE) into l_max_schedule_end_date
1503: from PSP_REP_SCH_EMP_V
1504: where assignment_id = l_assignment_id
1505: and schedule_end_date < l_schedule_begin_date
1506: and schedule_end_date >= l_time_period_start
1507: and not exists (select assignment_id from PSP_REP_SCH_EMP_V

Line 1507: and not exists (select assignment_id from PSP_REP_SCH_EMP_V

1503: from PSP_REP_SCH_EMP_V
1504: where assignment_id = l_assignment_id
1505: and schedule_end_date < l_schedule_begin_date
1506: and schedule_end_date >= l_time_period_start
1507: and not exists (select assignment_id from PSP_REP_SCH_EMP_V
1508: where assignment_id = l_assignment_id and
1509: l_schedule_begin_date between schedule_begin_date and schedule_end_date
1510: and schedule_begin_date < l_schedule_begin_date);
1511: if l_schedule_begin_date - l_max_schedule_end_date <=1 then

Line 1524: from PSP_REP_SCH_EMP_V

1520: return;
1521: else
1522: begin
1523: select min(schedule_begin_date) into l_temp_schedule_begin_date
1524: from PSP_REP_SCH_EMP_V
1525: where assignment_id = l_assignment_id and
1526: l_schedule_begin_date between schedule_begin_date and schedule_end_date
1527: and schedule_begin_date < l_schedule_begin_date;
1528: if l_temp_schedule_begin_date is not NULL then

Line 1562: from PSP_REP_SCH_EMP_V

1558: -- First, ensure that all variables that have to be returned are set to NULL
1559: l_Period2_start := NULL;
1560: l_Period2_End := NULL;
1561: Select MIN(SCHEDULE_BEGIN_DATE) into l_min_schedule_begin_date
1562: from PSP_REP_SCH_EMP_V
1563: where assignment_id = l_assignment_id
1564: and schedule_begin_date > l_schedule_end_date
1565: and schedule_begin_date <= l_time_period_end
1566: and not exists (select assignment_id from PSP_REP_SCH_EMP_V

Line 1566: and not exists (select assignment_id from PSP_REP_SCH_EMP_V

1562: from PSP_REP_SCH_EMP_V
1563: where assignment_id = l_assignment_id
1564: and schedule_begin_date > l_schedule_end_date
1565: and schedule_begin_date <= l_time_period_end
1566: and not exists (select assignment_id from PSP_REP_SCH_EMP_V
1567: where assignment_id = l_assignment_id and
1568: l_schedule_end_date between schedule_begin_date and schedule_end_date
1569: and schedule_end_date > l_schedule_end_date);
1570: if l_min_schedule_begin_date - l_schedule_begin_date <=1 then

Line 1582: from PSP_REP_SCH_EMP_V

1578: return;
1579: else
1580: begin
1581: select max(schedule_end_date) into l_temp_schedule_end_date
1582: from PSP_REP_SCH_EMP_V
1583: where assignment_id = l_assignment_id and
1584: l_schedule_end_date between schedule_begin_date and schedule_end_date
1585: and schedule_end_date > l_schedule_end_date;
1586: if l_temp_schedule_end_date is not NULL then