DBA Data[Home] [Help]

APPS.PA_ASGMT_WFSTD dependencies on PER_ASSIGNMENTS_F

Line 144: per_assignments_f assign,

140: rta.resource_id resource_id,
141: hou.name resource_organization_name,
142: assign.supervisor_id manager_id
143: FROM per_people_f per,
144: per_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

Line 4878: per_assignments_f assign,

4874: CURSOR l_resource_csr(l_resource_id IN NUMBER, p_start_date IN DATE) IS
4875: SELECT per.full_name resource_name,
4876: hou.name
4877: FROM per_people_f per,
4878: per_assignments_f assign,
4879: hr_all_organization_units hou,
4880: pa_resource_txn_attributes rta
4881: WHERE rta.resource_id = l_resource_id
4882: AND rta.person_id = per.person_id