DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on PER_ASSIGNMENT_STATUS_TYPES

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

3240: asg.effective_start_date,
3241: asg.business_group_id,
3242: ast.per_system_status assignment_status_type,
3243: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code
3244: FROM PER_ALL_ASSIGNMENTS asg, per_assignment_status_types ast -- Changing from per_assignments_f
3245: WHERE ast.assignment_status_type_id = asg.assignment_status_type_id
3246: -- only consider "Active" assignments as defined by below, also only look at
3247: -- assignments that are assigned to a valid person as of the report date.
3248: AND g_report_date between asg.effective_start_date and asg.effective_end_date