DBA Data[Home] [Help]

APPS.PA_SEARCH_PVT dependencies on PA_SCHEDULES

Line 1369: --from pa_schedules.

1365: BEGIN
1366:
1367: --if the status code is not passed to the function then the requirement has
1368: --multiple statuses - so get all the statuses for the requirement
1369: --from pa_schedules.
1370: IF p_status_code IS NULL THEN
1371:
1372: SELECT DISTINCT status_code BULK COLLECT INTO l_status_code_tbl
1373: FROM pa_schedules

Line 1373: FROM pa_schedules

1369: --from pa_schedules.
1370: IF p_status_code IS NULL THEN
1371:
1372: SELECT DISTINCT status_code BULK COLLECT INTO l_status_code_tbl
1373: FROM pa_schedules
1374: WHERE assignment_id = p_assignment_id;
1375:
1376: --if the status code is passed to the function then assign to the plsql table.
1377: ELSE