[Home] [Help]
51: and sob.set_of_books_id = pi.set_of_books_id;
52:
53: --Bug 4176129. Removed the UNION clause as at any point only one of the 2 SQLs would get executed
54: cursor chk_ra_exists_csr(c_budget_version_id pa_budget_versions.budget_version_id%type,
55: c_period_type gl_date_period_map.period_type%type,
56: c_period_set_name gl_sets_of_books.period_set_name%type) is
57: select 'Y' from dual
58: where exists (select 'Y' from pa_resource_assignments ra
59: where budget_version_id = c_budget_version_id
61: and ra.planning_end_date is NOT NULL /* bug 3673111 */
62: and not exists
63: ((
64: select 'Y' from
65: gl_date_period_map g
66: where trunc(g.accounting_date) between ra.planning_start_date and ra.planning_end_date
67: and g.period_set_name = c_period_set_name
68: and g.period_type = c_period_type
69: )));
86: where nvl(pi.org_id,-99) = c_org_id
87: and sob.set_of_books_id = pi.set_of_books_id
88: and exists
89: (select 1
90: from gl_date_period_map g
91: where g.period_set_name=c_period_set_name);
92:
93:
94: