APPS.GMS_AWARD_DIST_ENG dependencies on GMS_FUNDING_PATTERNS_ALL

Line 15: from gms_funding_patterns_all fp,

11: p_exp_item_dt in date,
12: p_org_id in number) is
13: select fp.funding_sequence,
14: fp.funding_pattern_id
15: from gms_funding_patterns_all fp,
16: pa_tasks t
17: where nvl(fp.retroactive_flag, 'N') = 'N'
18: and NVL(fp.status, 'N') = 'A'
19: -- and org_id = nvl(p_org_id, org_id )

Line 28: from gms_funding_patterns_all gfpa

24: and p_exp_item_dt between fp.start_date and nvl(fp.end_date, p_exp_item_dt)
25: union
26: select funding_sequence,
27: funding_pattern_id
28: from gms_funding_patterns_all gfpa
29: where nvl(retroactive_flag, 'N') = 'N'
30: and NVL(status, 'N') = 'A'
31: -- and org_id = NVL(p_org_id, org_id)
32: and ((org_id = p_org_id) or (org_id is null and p_org_id is null)) -- bug 2362489

Line 37: from gms_funding_patterns_all b,

33: and project_id = p_project_id
34: and task_id is null
35: and p_exp_item_dt between start_date and nvl(end_date, p_exp_item_dt)
36: and not exists (select '1'
37: from gms_funding_patterns_all b,
38: pa_tasks t1
39: where gfpa.project_id = b.project_id
40: and b.status = 'A'
41: and t1.task_id = p_task_id