DBA Data[Home] [Help]

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:
21: begin

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:
21: begin
22:
23: G_p_from_project_number := p_from_project_number ;

Line 67: pa_implementations_all imp1,

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

Line 1321: from pa_implementations_all

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

Line 1400: pa_implementations imp1

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