APPS.HR_AUTH_BRIDGE dependencies on HR_AUTH_BRIDGE

Line 1: package body hr_auth_bridge as

1: package body hr_auth_bridge as
2: /* $Header: hrathbrd.pkb 115.1 2002/05/29 05:42:14 pkm ship $ */
3:
4:
5: FUNCTION get_coverage

Line 577: AND hr_auth_bridge.get_per_system_status(paf.assignment_status_type_id) = 'ACTIVE_ASSIGN'

573: SELECT paf.assignment_id
574: FROM per_all_assignments_f paf
575: WHERE paf.person_id = p_person_id
576: AND TRUNC(SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
577: AND hr_auth_bridge.get_per_system_status(paf.assignment_status_type_id) = 'ACTIVE_ASSIGN'
578: AND paf.primary_flag = 'Y'
579: AND paf.assignment_type IN ('E','B')
580: ORDER BY paf.assignment_type DESC;
581:

Line 593: END hr_auth_bridge;

589:
590: RETURN l_assignment_id;
591: END;
592:
593: END hr_auth_bridge;