APPS.HR_REPORTS dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 413: -- join between per_ass_status_type_amends_tl and

409: --
410: begin
411: hr_utility.set_location('hr_reports.get_status',5);
412: -- bug fix 4157312
413: -- join between per_ass_status_type_amends_tl and
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

Line 414: -- per_ass_status_type_amends changed to outer join.

410: begin
411: hr_utility.set_location('hr_reports.get_status',5);
412: -- bug fix 4157312
413: -- join between per_ass_status_type_amends_tl and
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

Line 420: , per_ass_status_type_amends_tl btl

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
424: and b.ass_status_type_amend_id = btl.ass_status_type_amend_id(+)

Line 421: , per_ass_status_type_amends b

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
424: and b.ass_status_type_amend_id = btl.ass_status_type_amend_id(+)
425: and a.assignment_status_type_id = P_ASSIGNMENT_STATUS_TYPE_ID