APPS.PQP_VEHICLE_MILEAGE dependencies on PER_ALL_ASSIGNMENTS_F

Line 51: -- Get Error Info from per_all_assignments_f

47: OR (pet.element_name like cp_element_name||'%Mileage Res2%'
48: AND cp_ownership = 'C'))
49: AND pet.business_group_id=cp_business_group_id ;
50:
51: -- Get Error Info from per_all_assignments_f
52: CURSOR c_err_log
53: IS
54: select purt.location_name||' Needs to be linked to Assignment '
55: ||paaf.assignment_number||' of Employee '||papf.full_name ERROR_LOG

Line 57: ,per_all_assignments_f paaf

53: IS
54: select purt.location_name||' Needs to be linked to Assignment '
55: ||paaf.assignment_number||' of Employee '||papf.full_name ERROR_LOG
56: from pay_us_rpt_totals purt
57: ,per_all_assignments_f paaf
58: ,per_all_people_f papf
59: where purt.state_name = 'CARMILEAGE_UPGRADE'
60: and purt.tax_unit_id = 250
61: and paaf.assignment_id = purt.location_id