APPS.GHR_CPDF_STATRPT dependencies on PER_ASSIGNMENTS_F

Line 1232: FROM PER_ASSIGNMENTS_F asg

1228: asg.location_id,
1229: asg.effective_start_date,
1230: asg.business_group_id,
1231: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code
1232: FROM PER_ASSIGNMENTS_F asg
1233: WHERE
1234: -- only consider "Active" assignments as defined by below, also only look at
1235: -- assignments that are assigned to a valid person as of the report date.
1236: p_report_date between asg.effective_start_date and asg.effective_end_date

Line 1263: l_business_group_id per_assignments_f.business_group_id%type;

1259: FROM per_all_people_f
1260: WHERE person_id=p_person_id;
1261:
1262:
1263: l_business_group_id per_assignments_f.business_group_id%type;
1264: l_full_name per_people_f.full_name%type;
1265: l_ssn per_people_f.national_identifier%type;
1266: l_records_found BOOLEAN;
1267: l_mesgbuff1 VARCHAR2(4000);