DBA Data[Home] [Help]

APPS.PA_ASGMT_WFSTD dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 146: pa_resource_txn_attributes rta

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
149: AND rta.person_id = assign.person_id
150: AND assign.primary_flag = 'Y'

Line 4896: pa_resource_txn_attributes rta

4892: hou.name
4893: FROM per_people_f per,
4894: per_assignments_f assign,
4895: hr_all_organization_units hou,
4896: pa_resource_txn_attributes rta
4897: WHERE rta.resource_id = l_resource_id
4898: AND rta.person_id = per.person_id
4899: AND rta.person_id = assign.person_id
4900: AND assign.primary_flag = 'Y'