eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ASSIGNMENT_UTILS dependencies on PA_LOOKUPS

Line 505: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE

501: RAISE;
502: END Check_Assignment_Number_Or_Id;
503:
504: PROCEDURE Check_STF_PriorityName_Or_Code (p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
505: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE
506: ,p_check_id_flag IN VARCHAR2
507: ,x_staffing_priority_code OUT NOCOPY pa_project_assignments.staffing_priority_code%TYPE --File.Sql.39 bug 4440895
508: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
509: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 517: FROM pa_lookups

513: IF p_staffing_priority_code IS NOT NULL AND p_staffing_priority_code<>FND_API.G_MISS_CHAR THEN
514: IF p_check_id_flag = 'Y' THEN
515: SELECT lookup_code
516: INTO x_staffing_priority_code
517: FROM pa_lookups
518: WHERE lookup_type = 'STAFFING_PRIORITY_CODE'
519: AND lookup_code = p_staffing_priority_code;
520: ELSE
521: x_staffing_priority_code := p_staffing_priority_code;

Line 527: FROM pa_lookups

523: END IF;
524: ELSE
525: SELECT lookup_code
526: INTO x_staffing_priority_code
527: FROM pa_lookups
528: WHERE lookup_type = 'STAFFING_PRIORITY_CODE'
529: AND meaning = p_staffing_priority_name;
530: END IF;
531:

Line 561: l_lookup_code pa_lookups.lookup_code%TYPE;

557: p_apprvl_status_code IN VARCHAR2,
558: p_num_of_weeks IN NUMBER) RETURN VARCHAR2
559: IS
560:
561: l_lookup_code pa_lookups.lookup_code%TYPE;
562: l_meaning pa_lookups.meaning%TYPE;
563: l_today_date pa_project_assignments.start_date%TYPE;
564:
565: CURSOR get_meaning IS

Line 562: l_meaning pa_lookups.meaning%TYPE;

558: p_num_of_weeks IN NUMBER) RETURN VARCHAR2
559: IS
560:
561: l_lookup_code pa_lookups.lookup_code%TYPE;
562: l_meaning pa_lookups.meaning%TYPE;
563: l_today_date pa_project_assignments.start_date%TYPE;
564:
565: CURSOR get_meaning IS
566: SELECT meaning

Line 567: FROM pa_lookups

563: l_today_date pa_project_assignments.start_date%TYPE;
564:
565: CURSOR get_meaning IS
566: SELECT meaning
567: FROM pa_lookups
568: WHERE lookup_code = l_lookup_code
569: AND lookup_type = 'TEAM_ROLE_ACTIVITY_TYPE';
570:
571: BEGIN