DBA Data[Home] [Help]

APPS.PQP_VEHICLE_MILEAGE dependencies on PER_ALL_PEOPLE_F

Line 58: ,per_all_people_f papf

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
62: and fnd_date.canonical_to_date(purt.organization_name) between paaf.effective_start_date