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 5504: and gl.application_id = pa_period_process_pkg.application_id

5500: from gl_period_statuses gl,
5501: pa_implementations imp
5502: where pta.gl_period = gl.period_name
5503: and gl.set_of_books_id = imp.set_of_books_id
5504: and gl.application_id = pa_period_process_pkg.application_id
5505: and gl.adjustment_period_flag = 'N'
5506: and gl.closing_status in ('C','F','O','P')
5507: and gl.end_date between p_amttype_start_date
5508: and p_run_period_end_date)

Line 5586: and gl.application_id = pa_period_process_pkg.application_id

5582: from gl_period_statuses gl,
5583: pa_implementations imp
5584: where pta.gl_period = gl.period_name
5585: and gl.set_of_books_id = imp.set_of_books_id
5586: and gl.application_id = pa_period_process_pkg.application_id
5587: and gl.adjustment_period_flag = 'N'
5588: and gl.closing_status in ('C','F','O','P')
5589: and gl.end_date between p_amttype_start_date
5590: and p_run_period_end_date

Line 6258: and gl.application_id = pa_period_process_pkg.application_id

6254: From gl_period_statuses gl,
6255: pa_implementations imp
6256: where pta.gl_period = gl.period_name
6257: and gl.set_of_books_id = imp.set_of_books_id
6258: and gl.application_id = pa_period_process_pkg.application_id
6259: and gl.adjustment_period_flag = 'N'
6260: and gl.closing_status in ('C','F','O','P')
6261: and gl.end_date between p_amttype_start_date
6262: and p_run_period_end_date

Line 6357: and gl.application_id = pa_period_process_pkg.application_id

6353: From gl_period_statuses gl,
6354: pa_implementations imp
6355: where pta.gl_period = gl.period_name
6356: and gl.set_of_books_id = imp.set_of_books_id
6357: and gl.application_id = pa_period_process_pkg.application_id
6358: and gl.adjustment_period_flag = 'N'
6359: and gl.closing_status in ('C','F','O','P')
6360: and gl.end_date between p_amttype_start_date
6361: and p_run_period_end_date

Line 7566: and gl.application_id = pa_period_process_pkg.application_id

7562: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7563: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
7564: and pta.gl_period = gl.period_name
7565: and gl.set_of_books_id = imp.set_of_books_id
7566: and gl.application_id = pa_period_process_pkg.application_id
7567: and gl.adjustment_period_flag = 'N'
7568: and gl.closing_status in ('C','F','O','P')
7569: and gl.end_date >= v_amttype_start_date
7570: and gl.end_date <= v_run_period_end_date

Line 8216: and gl.application_id = pa_period_process_pkg.application_id

8212: pta.project_id = l_get_proj.project_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8213: and pta.task_id = l_get_proj.task_id /* Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id */
8214: and pta.gl_period = gl.period_name
8215: and gl.set_of_books_id = imp.set_of_books_id
8216: and gl.application_id = pa_period_process_pkg.application_id
8217: and gl.adjustment_period_flag = 'N'
8218: and gl.closing_status in ('C','F','O','P')
8219: and gl.end_date >= v_amttype_start_date
8220: and gl.end_date <= v_rel_period_end_date