DBA Data[Home] [Help]

APPS.GHR_CPDF_STATRPT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1269: from PER_ASSIGNMENT_STATUS_TYPES ast

1265: -- assignments that are assigned to a valid person as of the report date.
1266: p_report_date between asg.effective_start_date and asg.effective_end_date
1267: AND asg.assignment_status_type_id in
1268: (select ast.assignment_status_type_id
1269: from PER_ASSIGNMENT_STATUS_TYPES ast
1270: where ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN'))
1271: AND asg.assignment_type <> 'B'
1272: AND asg.position_id IS NOT NULL
1273: AND ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency