DBA Data[Home] [Help]

APPS.PA_SEARCH_PVT dependencies on PA_SCHEDULES

Line 1419: --from pa_schedules.

1415: BEGIN
1416:
1417: --if the status code is not passed to the function then the requirement has
1418: --multiple statuses - so get all the statuses for the requirement
1419: --from pa_schedules.
1420: IF p_status_code IS NULL THEN
1421:
1422: SELECT DISTINCT status_code BULK COLLECT INTO l_status_code_tbl
1423: FROM pa_schedules

Line 1423: FROM pa_schedules

1419: --from pa_schedules.
1420: IF p_status_code IS NULL THEN
1421:
1422: SELECT DISTINCT status_code BULK COLLECT INTO l_status_code_tbl
1423: FROM pa_schedules
1424: WHERE assignment_id = p_assignment_id;
1425:
1426: --if the status code is passed to the function then assign to the plsql table.
1427: ELSE