APPS.PA_ASGMT_WFSTD dependencies on PA_SECURITY_PVT

Line 5946: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id

5942: fnd_objects fob,
5943: fnd_user fnd,
5944: pa_resources_denorm res,
5945: /* Commenting this for performance tuning Bug#2499051
5946: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
5947: from dual) temp, */
5948: pa_project_assignments asgn,
5949: pa_wf_ntf_performers ntf,
5950: wf_roles wf,

Line 5969: AND fg.menu_id = pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') /* temp.menu_id commented for bug#2499051 */

5965: AND fg.instance_pk1_value = TO_CHAR(res.resource_organization_id)
5966: AND fg.instance_type = 'INSTANCE'
5967: AND fg.object_id = fob.object_id
5968: AND fob.obj_name = 'ORGANIZATION'
5969: AND fg.menu_id = pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') /* temp.menu_id commented for bug#2499051 */
5970: AND fg.grantee_type = 'USER'
5971: AND trunc(SYSDATE) BETWEEN trunc(fg.start_date)
5972: AND trunc(NVL(fg.END_DATE, SYSDATE+1));
5973: