APPS.PA_ASGMT_WFSTD dependencies on PA_SECURITY_PVT

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

5958: fnd_objects fob,
5959: fnd_user fnd,
5960: pa_resources_denorm res,
5961: /* Commenting this for performance tuning Bug#2499051
5962: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
5963: from dual) temp, */
5964: pa_project_assignments asgn,
5965: pa_wf_ntf_performers ntf,
5966: wf_roles wf,

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

5981: AND fg.instance_pk1_value = TO_CHAR(res.resource_organization_id)
5982: AND fg.instance_type = 'INSTANCE'
5983: AND fg.object_id = fob.object_id
5984: AND fob.obj_name = 'ORGANIZATION'
5985: AND fg.menu_id = pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') /* temp.menu_id commented for bug#2499051 */
5986: AND fg.grantee_type = 'USER'
5987: AND trunc(SYSDATE) BETWEEN trunc(fg.start_date)
5988: AND trunc(NVL(fg.END_DATE, SYSDATE+1));
5989: