eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CPDF_STATRPT dependencies on PER_ASSIGNMENTS_F

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

Line 1298: l_business_group_id per_assignments_f.business_group_id%type;

1294: --Bug # 9329643
1295: l_employee_number per_people_f.employee_number%TYPE;
1296:
1297:
1298: l_business_group_id per_assignments_f.business_group_id%type;
1299: l_full_name per_people_f.full_name%type;
1300: l_ssn per_people_f.national_identifier%type;
1301: l_records_found BOOLEAN;
1302: l_mesgbuff1 VARCHAR2(4000);