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_TXN_ACCUMS dependencies on GL_DATE_PERIOD_MAP

Line 2616: -- Removed joins to gl_date_period_map and related entities

2612: -- History
2613: -- dd-mmm-1997 Vbanal Created.
2614: --
2615: -- 15-OCT-2001 Jwhite Modified for the Enhanced Period Processing effort.
2616: -- Removed joins to gl_date_period_map and related entities
2617: -- and referenced new GL and PA period name columns on cdl.
2618: --
2619: -- 13-OCT-2002 Sacgupta Bug # 2580808.
2620: -- Modified for the Enhanced Period Processing effort.

Line 2621: -- Fetching PA period name and GL period name from gl_date_period_map

2617: -- and referenced new GL and PA period name columns on cdl.
2618: --
2619: -- 13-OCT-2002 Sacgupta Bug # 2580808.
2620: -- Modified for the Enhanced Period Processing effort.
2621: -- Fetching PA period name and GL period name from gl_date_period_map
2622: -- and related entities for inserting into pa_txn_accum table when
2623: -- GL and PA period name columns on cdl are null.
2624: --
2625: -- 05-NOV-2002 Sacgupta Bug # 2650900.

Line 2628: -- gl_date_period_map and related entities for inserting into

2624: --
2625: -- 05-NOV-2002 Sacgupta Bug # 2650900.
2626: -- Removed the condition x_mode <> I. So now both Update process and
2627: -- Refresh process will fetch PA period name and GL period name from
2628: -- gl_date_period_map and related entities for inserting into
2629: -- pa_txn_accum table when GL and PA period name columns on cdl are null.
2630: --
2631: -- 20-MAY-2003 jwhite For r11i.PA.L Burdening Enhancements, modified the following
2632: -- cursors: selcdls1, selcdls2, selcdls3.

Line 2789: gl_date_period_map p,

2785: SELECT
2786: p.period_name pa_period1,
2787: g.period_name gl_period1
2788: FROM
2789: gl_date_period_map p,
2790: gl_date_period_map g,
2791: pa_expenditures_all pe,
2792: pa_expenditure_types et,
2793: pa_expenditure_items_all ei,

Line 2790: gl_date_period_map g,

2786: p.period_name pa_period1,
2787: g.period_name gl_period1
2788: FROM
2789: gl_date_period_map p,
2790: gl_date_period_map g,
2791: pa_expenditures_all pe,
2792: pa_expenditure_types et,
2793: pa_expenditure_items_all ei,
2794: pa_cost_distribution_lines_all cdl,

Line 2980: -- Removed joins to gl_date_period_map and related entities

2976: -- History
2977: -- dd-mmm-1997 Vbanal Created.
2978: --
2979: -- 15-OCT-2001 Jwhite Modified for the Enhanced Period Processing effort.
2980: -- Removed joins to gl_date_period_map and related entities
2981: -- and referenced new GL and PA period name columns on rdl.
2982: --
2983: -- 13-OCT-2002 Sacgupta Bug # 2580808.
2984: -- Modified for the Enhanced Period Processing effort.

Line 2985: -- Fetching PA period name and GL period name from gl_date_period_map

2981: -- and referenced new GL and PA period name columns on rdl.
2982: --
2983: -- 13-OCT-2002 Sacgupta Bug # 2580808.
2984: -- Modified for the Enhanced Period Processing effort.
2985: -- Fetching PA period name and GL period name from gl_date_period_map
2986: -- and related entities for inserting into pa_txn_accum table when
2987: -- GL and PA period name columns on rdl are null.
2988: --
2989: -- 05-NOV-2002 Sacgupta Bug # 2650900.

Line 2992: -- gl_date_period_map and related entities for inserting into

2988: --
2989: -- 05-NOV-2002 Sacgupta Bug # 2650900.
2990: -- Removed the condition x_mode <> I. So now both Update process and
2991: -- Refresh process will fetch PA period name and GL period name from
2992: -- gl_date_period_map and related entities for inserting into
2993: -- pa_txn_accum table when GL and PA period name columns on rdl are null.
2994: --
2995: -- 07-Jul-2004 Sacgupta Bug # 3736097.
2996: -- Commented out all occurence of x_end_project_id.

Line 3063: gl_date_period_map p,

3059: SELECT
3060: p.period_name pa_period1,
3061: g.period_name gl_period1
3062: FROM
3063: gl_date_period_map p,
3064: gl_date_period_map g,
3065: pa_expenditures_all pe,
3066: pa_expenditure_types et,
3067: pa_expenditure_items_all ei,

Line 3064: gl_date_period_map g,

3060: p.period_name pa_period1,
3061: g.period_name gl_period1
3062: FROM
3063: gl_date_period_map p,
3064: gl_date_period_map g,
3065: pa_expenditures_all pe,
3066: pa_expenditure_types et,
3067: pa_expenditure_items_all ei,
3068: pa_cust_rev_dist_lines rdl,

Line 3208: -- Removed joins to gl_date_period_map and related entities

3204: -- History
3205: -- dd-mmm-1997 Vbanal Created.
3206: --
3207: -- 15-OCT-2001 Jwhite Modified for the Enhanced Period Processing effort.
3208: -- Removed joins to gl_date_period_map and related entities
3209: -- and referenced new GL and PA period name columns on erdls
3210: --
3211: -- 13-OCT-2002 Sacgupta Bug # 2580808.
3212: -- Modified for the Enhanced Period Processing effort.

Line 3213: -- Fetching PA period name and GL period name from gl_date_period_map

3209: -- and referenced new GL and PA period name columns on erdls
3210: --
3211: -- 13-OCT-2002 Sacgupta Bug # 2580808.
3212: -- Modified for the Enhanced Period Processing effort.
3213: -- Fetching PA period name and GL period name from gl_date_period_map
3214: -- and related entities for inserting into pa_txn_accum table when
3215: -- GL and PA period name columns on erdls are null.
3216: --
3217: -- 05-NOV-2002 Sacgupta Bug # 2650900.

Line 3220: -- gl_date_period_map and related entities for inserting into

3216: --
3217: -- 05-NOV-2002 Sacgupta Bug # 2650900.
3218: -- Removed the condition x_mode <> I. So now both Update process and
3219: -- Refresh process will fetch PA period name and GL period name from
3220: -- gl_date_period_map and related entities for inserting into
3221: -- pa_txn_accum table when GL and PA period name columns on erdls are null.
3222: --
3223: -- 07-JUL-2004 Sacgupta Bug # 3736097.
3224: -- Commented out all occurence of x_end_project_id.

Line 3282: gl_date_period_map p,

3278: SELECT
3279: p.period_name pa_period1,
3280: g.period_name gl_period1
3281: FROM
3282: gl_date_period_map p,
3283: gl_date_period_map g,
3284: pa_events ev,
3285: pa_event_types evt,
3286: pa_cust_event_rev_dist_lines erdl,

Line 3283: gl_date_period_map g,

3279: p.period_name pa_period1,
3280: g.period_name gl_period1
3281: FROM
3282: gl_date_period_map p,
3283: gl_date_period_map g,
3284: pa_events ev,
3285: pa_event_types evt,
3286: pa_cust_event_rev_dist_lines erdl,
3287: pa_draft_revenues dr,

Line 3427: -- Removed joins to gl_date_period_map and related entities

3423: -- History
3424: -- dd-mmm-1997 Vbanal Created.
3425: --
3426: -- 15-OCT-2001 Jwhite Modified for the Enhanced Period Processing effort.
3427: -- Removed joins to gl_date_period_map and related entities
3428: -- and referenced new GL and PA period name columns.
3429: --
3430: -- 13-OCT-2002 Sacgupta Bug # 2580808.
3431: -- Modified for the Enhanced Period Processing effort.

Line 3432: -- Fetching PA period name and GL period name from gl_date_period_map

3428: -- and referenced new GL and PA period name columns.
3429: --
3430: -- 13-OCT-2002 Sacgupta Bug # 2580808.
3431: -- Modified for the Enhanced Period Processing effort.
3432: -- Fetching PA period name and GL period name from gl_date_period_map
3433: -- and related entities for inserting into pa_txn_accum table when
3434: -- GL and PA period name columns on rdl are null.
3435: --
3436: -- 05-NOV-2002 Sacgupta Bug # 2650900.

Line 3439: -- gl_date_period_map and related entities for inserting into

3435: --
3436: -- 05-NOV-2002 Sacgupta Bug # 2650900.
3437: -- Removed the condition x_mode <> I. So now both Update process and
3438: -- Refresh process will fetch PA period name and GL period name from
3439: -- gl_date_period_map and related entities for inserting into
3440: -- pa_txn_accum table when GL and PA period name columns on rdl are null.
3441: --
3442: -- 07-JUL-2004 Sacgupta Bug # 3736097.
3443: -- Commented out all occurence of x_end_project_id.

Line 3561: gl_date_period_map p,

3557: SELECT
3558: p.period_name pa_period1,
3559: g.period_name gl_period1
3560: FROM
3561: gl_date_period_map p,
3562: gl_date_period_map g,
3563: pa_draft_revenues dr,
3564: pa_implementations pi,
3565: gl_sets_of_books sob

Line 3562: gl_date_period_map g,

3558: p.period_name pa_period1,
3559: g.period_name gl_period1
3560: FROM
3561: gl_date_period_map p,
3562: gl_date_period_map g,
3563: pa_draft_revenues dr,
3564: pa_implementations pi,
3565: gl_sets_of_books sob
3566: WHERE