DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on FND_GRANTS

Line 81: fnd_grants fg,

77: and l_start_date between resource_effective_start_date and resource_effective_end_date
78: UNION
79: SELECT per.person_id approver_id
80: from pa_resources_denorm res_denorm,
81: fnd_grants fg,
82: fnd_objects fob,
83: per_all_people_f per,
84: wf_roles wfr,
85: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id

Line 103: fnd_grants fg,

99: and trunc(SYSDATE) between trunc(fg.start_date) and trunc(NVL(fg.end_date, SYSDATE+1))
100: UNION
101: select per.person_id approver_id
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

Line 128: fnd_grants fg2,

124: and per.person_id not in
125: (
126: select per2.person_Id
127: from
128: fnd_grants fg2,
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,