DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 3377: FROM PER_ALL_ASSIGNMENTS asg, per_assignment_status_types ast -- Changing from per_assignments_f

3373: asg.effective_start_date,
3374: asg.business_group_id,
3375: ast.per_system_status assignment_status_type,
3376: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code
3377: FROM PER_ALL_ASSIGNMENTS asg, per_assignment_status_types ast -- Changing from per_assignments_f
3378: WHERE ast.assignment_status_type_id = asg.assignment_status_type_id
3379: -- only consider "Active" assignments as defined by below, also only look at
3380: -- assignments that are assigned to a valid person as of the report date.
3381: AND g_report_date between asg.effective_start_date and asg.effective_end_date