DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PER_PEOPLE_F

Line 106: per_people_f per,

102: from pa_resources_denorm res_denorm,
103: fnd_grants fg,
104: fnd_objects fob,
105: wf_roles wfr,
106: per_people_f per,
107: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id
108: from dual) res_auth_menu
109: where fob.obj_name = 'ORGANIZATION'
110: and res_denorm.resource_id = l_resource_id

Line 133: per_people_f per2

129: fnd_objects fob2,
130: wf_roles wfr2,
131: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
132: from dual) prmry_contact_menu,
133: per_people_f per2
134: where fob.obj_name = 'ORGANIZATION'
135: and fg2.instance_pk1_value = to_char(res_denorm.resource_organization_id)
136: and fg2.instance_type = 'INSTANCE'
137: and fg2.object_id = fob2.object_id