DBA Data[Home] [Help]

APPS.GHR_CPDF_STATRPT dependencies on PER_ALL_ASSIGNMENTS

Line 1262: FROM PER_ALL_ASSIGNMENTS asg -- Bug # 10632194 changed from PER_ASSIGNMENTS_F to match EHRI

1258: asg.location_id,
1259: asg.effective_start_date,
1260: asg.business_group_id,
1261: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code
1262: FROM PER_ALL_ASSIGNMENTS asg -- Bug # 10632194 changed from PER_ASSIGNMENTS_F to match EHRI
1263: WHERE
1264: -- only consider "Active" assignments as defined by below, also only look at
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