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_BURDEN_COSTING dependencies on PA_PROJECT_TYPES

Line 210: burden_account_flag pa_project_types.burden_account_flag%TYPE,

206: TYPE proj_rec_type IS RECORD (
207: project_id pa_projects_all.project_id%TYPE,
208: segment1 pa_projects_all.segment1%TYPE,
209: org_id pa_projects_all.org_id%TYPE,
210: burden_account_flag pa_project_types.burden_account_flag%TYPE,
211: dest_project_id pa_projects_all.project_id%TYPE,
212: dest_task_id pa_tasks.task_id%TYPE,
213: burden_amt_display_method pa_project_types.burden_amt_display_method%TYPE
214: );

Line 213: burden_amt_display_method pa_project_types.burden_amt_display_method%TYPE

209: org_id pa_projects_all.org_id%TYPE,
210: burden_account_flag pa_project_types.burden_account_flag%TYPE,
211: dest_project_id pa_projects_all.project_id%TYPE,
212: dest_task_id pa_tasks.task_id%TYPE,
213: burden_amt_display_method pa_project_types.burden_amt_display_method%TYPE
214: );
215:
216: proj_rec proj_rec_type;
217:

Line 224: TYPE Typ_burden_account_flag IS TABLE OF pa_project_types.burden_account_flag%TYPE INDEX BY BINARY_INTEGER;

220:
221: TYPE Typ_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
222: TYPE Typ_segment1 IS TABLE OF pa_projects_all.segment1%TYPE INDEX BY BINARY_INTEGER;
223: TYPE Typ_org_id IS TABLE OF pa_projects_all.org_id%TYPE INDEX BY BINARY_INTEGER;
224: TYPE Typ_burden_account_flag IS TABLE OF pa_project_types.burden_account_flag%TYPE INDEX BY BINARY_INTEGER;
225: TYPE Typ_dest_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
226: TYPE Typ_dest_task_id IS TABLE OF pa_tasks.task_id%TYPE INDEX BY BINARY_INTEGER;
227: TYPE Typ_burden_amt_display_method IS TABLE OF pa_project_types.burden_amt_display_method%TYPE INDEX BY BINARY_INTEGER;
228:

Line 227: TYPE Typ_burden_amt_display_method IS TABLE OF pa_project_types.burden_amt_display_method%TYPE INDEX BY BINARY_INTEGER;

223: TYPE Typ_org_id IS TABLE OF pa_projects_all.org_id%TYPE INDEX BY BINARY_INTEGER;
224: TYPE Typ_burden_account_flag IS TABLE OF pa_project_types.burden_account_flag%TYPE INDEX BY BINARY_INTEGER;
225: TYPE Typ_dest_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
226: TYPE Typ_dest_task_id IS TABLE OF pa_tasks.task_id%TYPE INDEX BY BINARY_INTEGER;
227: TYPE Typ_burden_amt_display_method IS TABLE OF pa_project_types.burden_amt_display_method%TYPE INDEX BY BINARY_INTEGER;
228:
229: l_tbl_project_id Typ_project_id;
230: l_tbl_segment1 Typ_segment1;
231: l_tbl_org_id Typ_org_id;

Line 257: pa_project_types_all pt -- pa_project_types_all changed to pa_project_types for Bug# 5743708 /pa_project_types is changed to pa_project_types_all for the bug 6610145/

253: , pt.burden_sum_dest_project_id dest_project_id
254: , pt.burden_sum_dest_task_id dest_task_id
255: , upper(pt.burden_amt_display_method) burden_amt_display_method
256: from pa_projects_all p, -- pa_projects_all changed to pa_projects for Bug# 5743708 /*pa_projects is changed to pa_projects_all for the bug 6610145*/
257: pa_project_types_all pt -- pa_project_types_all changed to pa_project_types for Bug# 5743708 /*pa_project_types is changed to pa_project_types_all for the bug 6610145*/
258: where pt.project_type = p.project_type
259: and p.segment1 between p_start_project_number and p_end_project_number /*2255068*/
260: and ( pt.burden_amt_display_method in ('D','d') or
261: pt.burden_amt_display_method in ('S','s') and

Line 310: pa_project_types_all pt /changed pa_project_types to pa_project_types_all for the bug 13109368 /

306: , pt.burden_sum_dest_project_id dest_project_id
307: , pt.burden_sum_dest_task_id dest_task_id
308: , upper(pt.burden_amt_display_method) burden_amt_display_method
309: from pa_projects_all p, /*changed pa_projects to pa_projects_all for the bug 13109368 */
310: pa_project_types_all pt /*changed pa_project_types to pa_project_types_all for the bug 13109368 */
311: where pt.project_type = p.project_type
312: and p.segment1 between p_start_project_number and p_end_project_number
313: and ( pt.burden_amt_display_method in ('D','d') or
314: pt.burden_amt_display_method in ('S','s') and

Line 2793: * pa_project_types_all instead of pa_projects, pa_project_types.

2789: -- Bug 2838499: Used pa_projects Org view instead of table.
2790: -- added org_id join between pt and p.
2791: /*
2792: * Bug 4914022 : Changed projects cursor to join to pa_projects_all
2793: * pa_project_types_all instead of pa_projects, pa_project_types.
2794: */
2795: Cursor projects is
2796: select /*+ use_hash(pt p) */
2797: p.project_id , p.segment1

Line 2801: pa_project_types_all pt

2797: p.project_id , p.segment1
2798: , upper(nvl(pt.burden_account_flag,'N')) burden_account_flag
2799: , upper(pt.burden_amt_display_method) burden_amt_display_method
2800: from pa_projects_all p,
2801: pa_project_types_all pt
2802: where pt.project_type = p.project_type
2803: and pt.org_id = p.org_id /*5368274*/
2804: and pt.burden_amt_display_method in ('D','d')
2805: and p.project_id = nvl(x_project_id,p.project_id) /* bug#2791563 */