APPS.PA_ASGMT_WFSTD dependencies on PER_ALL_ASSIGNMENTS_F

Line 144: per_all_assignments_f assign,

140: rta.resource_id resource_id,
141: hou.name resource_organization_name,
142: assign.supervisor_id manager_id
143: FROM per_all_people_f per,
144: per_all_assignments_f assign,
145: hr_all_organization_units hou,
146: pa_resource_txn_attributes rta
147: WHERE rta.resource_id = l_resource_id
148: AND rta.person_id = per.person_id