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.GMS_TRANSACTIONS_PUB dependencies on GMS_FUNDING_PATTERNS_ALL

Line 268: from gms_funding_patterns_all fp,

264: -- =================================================================================
265: CURSOR FUND_PATTERN_EXIST IS
266: select fp.funding_name,
267: fp.funding_pattern_id
268: from gms_funding_patterns_all fp,
269: pa_tasks t
270: where nvl(fp.retroactive_flag, 'N') = 'N'
271: and NVL(fp.status, 'N') = 'A'
272: and fp.project_id = p_project_id

Line 279: from gms_funding_patterns_all gfpa

275: and P_expenditure_item_date between fp.start_date and NVL(fp.end_date, P_expenditure_item_date )
276: union
277: select gfpa.funding_name,
278: gfpa.funding_pattern_id
279: from gms_funding_patterns_all gfpa
280: where nvl(gfpa.retroactive_flag, 'N') = 'N'
281: and NVL(gfpa.status, 'N') = 'A'
282: and gfpa.project_id = p_project_id
283: and gfpa.task_id is null

Line 284: and not exists (select '1' from gms_funding_patterns_all b, pa_tasks t

280: where nvl(gfpa.retroactive_flag, 'N') = 'N'
281: and NVL(gfpa.status, 'N') = 'A'
282: and gfpa.project_id = p_project_id
283: and gfpa.task_id is null
284: and not exists (select '1' from gms_funding_patterns_all b, pa_tasks t
285: where gfpa.project_id = b.project_id
286: and nvl(b.status,'x') = 'A'
287: and t.task_id = p_task_id
288: and b.task_id = t.top_task_id)