APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_IMPLEMENTATIONS

Line 17: from pa_implementations_all all1

13: p_gl_period_name in varchar2 ,
14: p_request_id in number ) IS
15: CURSOR org_cv IS
16: /* select all1.org_id
17: from pa_implementations_all all1
18: where all1.set_of_books_id = ( select s1.set_of_books_id
19: from pa_implementations s1); */
20: /* commented the above and added below for bug 10401877 */
21: select org_id from pa_implementations;

Line 19: from pa_implementations s1); */

15: CURSOR org_cv IS
16: /* select all1.org_id
17: from pa_implementations_all all1
18: where all1.set_of_books_id = ( select s1.set_of_books_id
19: from pa_implementations s1); */
20: /* commented the above and added below for bug 10401877 */
21: select org_id from pa_implementations;
22:
23: begin

Line 21: select org_id from pa_implementations;

17: from pa_implementations_all all1
18: where all1.set_of_books_id = ( select s1.set_of_books_id
19: from pa_implementations s1); */
20: /* commented the above and added below for bug 10401877 */
21: select org_id from pa_implementations;
22:
23: begin
24:
25: G_p_from_project_number := p_from_project_number ;

Line 69: pa_implementations_all imp1,

65: G_p_gl_end_date ,
66: G_coa_id ,
67: G_sob
68: FROM gl_period_statuses gl1,
69: pa_implementations_all imp1,
70: gl_sets_of_books sob1
71: WHERE
72: imp1.org_id = p_org_id
73: AND imp1.set_of_books_id = gl1.set_of_books_id

Line 1323: from pa_implementations_all

1319: G_gl_period_name := null;
1320:
1321: select set_of_books_id
1322: into G_set_of_books_id
1323: from pa_implementations_all
1324: where nvl(org_id,-1) = nvl(p_org_id,-1);
1325:
1326: end if;
1327:

Line 1402: pa_implementations imp1

1398: to_char(gl1.start_date,'DD-MON-RR')
1399: into
1400: l_gl_start_date
1401: from gl_period_statuses gl1 ,
1402: pa_implementations imp1
1403: where gl1.period_name = p_gl_period_name
1404: and gl1.application_id = 101
1405: and gl1.set_of_books_id = imp1.set_of_books_id;
1406: