APPS.HR_REPORTS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 404: l_user_status per_assignment_status_types_tl.user_status%type;

400: p_assignment_status_type_id NUMBER,
401: p_legislation_code VARCHAR2) return VARCHAR2
402: --
403: AS
404: l_user_status per_assignment_status_types_tl.user_status%type;
405: --
406: begin
407: --
408: hr_utility.trace('Entered Get_Status');

Line 418: from per_assignment_status_types_tl atl

414: -- per_ass_status_type_amends changed to outer join.
415:
416: SELECT nvl(btl.user_status,atl.user_status)
417: INTO l_user_status
418: from per_assignment_status_types_tl atl
419: , per_assignment_status_types a
420: , per_ass_status_type_amends_tl btl
421: , per_ass_status_type_amends b
422: where b.assignment_status_type_id(+) = a.assignment_status_type_id

Line 419: , per_assignment_status_types a

415:
416: SELECT nvl(btl.user_status,atl.user_status)
417: INTO l_user_status
418: from per_assignment_status_types_tl atl
419: , per_assignment_status_types a
420: , per_ass_status_type_amends_tl btl
421: , per_ass_status_type_amends b
422: where b.assignment_status_type_id(+) = a.assignment_status_type_id
423: and a.assignment_status_type_id = atl.assignment_status_type_id