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.PA_ALLOC_RUN dependencies on PA_PERIOD_PROCESS_PKG

Line 5527: and gl.application_id = pa_period_process_pkg.application_id

5523: from gl_period_statuses gl,
5524: pa_implementations imp
5525: where pta.gl_period = gl.period_name
5526: and gl.set_of_books_id = imp.set_of_books_id
5527: and gl.application_id = pa_period_process_pkg.application_id
5528: and gl.adjustment_period_flag = 'N'
5529: and gl.closing_status in ('C','F','O','P')
5530: and gl.end_date between p_amttype_start_date
5531: and p_run_period_end_date)

Line 5609: and gl.application_id = pa_period_process_pkg.application_id

5605: from gl_period_statuses gl,
5606: pa_implementations imp
5607: where pta.gl_period = gl.period_name
5608: and gl.set_of_books_id = imp.set_of_books_id
5609: and gl.application_id = pa_period_process_pkg.application_id
5610: and gl.adjustment_period_flag = 'N'
5611: and gl.closing_status in ('C','F','O','P')
5612: and gl.end_date between p_amttype_start_date
5613: and p_run_period_end_date

Line 6281: and gl.application_id = pa_period_process_pkg.application_id

6277: From gl_period_statuses gl,
6278: pa_implementations imp
6279: where pta.gl_period = gl.period_name
6280: and gl.set_of_books_id = imp.set_of_books_id
6281: and gl.application_id = pa_period_process_pkg.application_id
6282: and gl.adjustment_period_flag = 'N'
6283: and gl.closing_status in ('C','F','O','P')
6284: and gl.end_date between p_amttype_start_date
6285: and p_run_period_end_date

Line 6380: and gl.application_id = pa_period_process_pkg.application_id

6376: From gl_period_statuses gl,
6377: pa_implementations imp
6378: where pta.gl_period = gl.period_name
6379: and gl.set_of_books_id = imp.set_of_books_id
6380: and gl.application_id = pa_period_process_pkg.application_id
6381: and gl.adjustment_period_flag = 'N'
6382: and gl.closing_status in ('C','F','O','P')
6383: and gl.end_date between p_amttype_start_date
6384: and p_run_period_end_date

Line 7627: and gl.application_id = pa_period_process_pkg.application_id

7623: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7624: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7625: and pta.gl_period = gl.period_name
7626: and gl.set_of_books_id = imp.set_of_books_id
7627: and gl.application_id = pa_period_process_pkg.application_id
7628: and gl.adjustment_period_flag = 'N'
7629: and gl.closing_status in ('C','F','O','P')
7630: and gl.end_date >= v_amttype_start_date
7631: and gl.end_date <= v_run_period_end_date

Line 8321: and gl.application_id = pa_period_process_pkg.application_id

8317: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8318: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8319: and pta.gl_period = gl.period_name
8320: and gl.set_of_books_id = imp.set_of_books_id
8321: and gl.application_id = pa_period_process_pkg.application_id
8322: and gl.adjustment_period_flag = 'N'
8323: and gl.closing_status in ('C','F','O','P')
8324: and gl.end_date >= v_amttype_start_date
8325: and gl.end_date <= v_rel_period_end_date