eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_RESOURCES_DENORM

Line 69: from pa_resources_denorm res_denorm

65: SELECT 'Y' into l_dummy
66: FROM dual
67: WHERE l_approver_id in
68: (SELECT pa_resource_utils.get_hr_manager_id(res_denorm.resource_id,l_start_date) approver_id
69: from pa_resources_denorm res_denorm
70: WHERE l_start_date between resource_effective_start_date
71: and resource_effective_end_date
72: START WITH resource_id = l_resource_id
73: CONNECT BY

Line 80: from pa_resources_denorm res_denorm,

76: and l_start_date between prior resource_effective_start_date and prior resource_effective_end_date
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,

Line 102: from pa_resources_denorm res_denorm,

98: and fg.menu_id = prmry_contact_menu.menu_id
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,