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 2707: -- Removed joins to gl_date_period_map and related entities

2703: -- History
2704: -- dd-mmm-1997 Vbanal Created.
2705: --
2706: -- 15-OCT-2001 Jwhite Modified for the Enhanced Period Processing effort.
2707: -- Removed joins to gl_date_period_map and related entities
2708: -- and referenced new GL and PA period name columns on cdl.
2709: --
2710: -- 13-OCT-2002 Sacgupta Bug # 2580808.
2711: -- Modified for the Enhanced Period Processing effort.

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

2708: -- and referenced new GL and PA period name columns on cdl.
2709: --
2710: -- 13-OCT-2002 Sacgupta Bug # 2580808.
2711: -- Modified for the Enhanced Period Processing effort.
2712: -- Fetching PA period name and GL period name from gl_date_period_map
2713: -- and related entities for inserting into pa_txn_accum table when
2714: -- GL and PA period name columns on cdl are null.
2715: --
2716: -- 05-NOV-2002 Sacgupta Bug # 2650900.

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

2715: --
2716: -- 05-NOV-2002 Sacgupta Bug # 2650900.
2717: -- Removed the condition x_mode <> I. So now both Update process and
2718: -- Refresh process will fetch PA period name and GL period name from
2719: -- gl_date_period_map and related entities for inserting into
2720: -- pa_txn_accum table when GL and PA period name columns on cdl are null.
2721: --
2722: -- 20-MAY-2003 jwhite For r11i.PA.L Burdening Enhancements, modified the following
2723: -- cursors: selcdls1, selcdls2, selcdls3.

Line 2902: gl_date_period_map p,

2898: SELECT
2899: p.period_name pa_period1,
2900: g.period_name gl_period1
2901: FROM
2902: gl_date_period_map p,
2903: gl_date_period_map g,
2904: pa_expenditures_all pe,
2905: pa_expenditure_types et,
2906: pa_expenditure_items_all ei,

Line 2903: gl_date_period_map g,

2899: p.period_name pa_period1,
2900: g.period_name gl_period1
2901: FROM
2902: gl_date_period_map p,
2903: gl_date_period_map g,
2904: pa_expenditures_all pe,
2905: pa_expenditure_types et,
2906: pa_expenditure_items_all ei,
2907: pa_cost_distribution_lines_all cdl,

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

3156: -- History
3157: -- dd-mmm-1997 Vbanal Created.
3158: --
3159: -- 15-OCT-2001 Jwhite Modified for the Enhanced Period Processing effort.
3160: -- Removed joins to gl_date_period_map and related entities
3161: -- and referenced new GL and PA period name columns on rdl.
3162: --
3163: -- 13-OCT-2002 Sacgupta Bug # 2580808.
3164: -- Modified for the Enhanced Period Processing effort.

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

3161: -- and referenced new GL and PA period name columns on rdl.
3162: --
3163: -- 13-OCT-2002 Sacgupta Bug # 2580808.
3164: -- Modified for the Enhanced Period Processing effort.
3165: -- Fetching PA period name and GL period name from gl_date_period_map
3166: -- and related entities for inserting into pa_txn_accum table when
3167: -- GL and PA period name columns on rdl are null.
3168: --
3169: -- 05-NOV-2002 Sacgupta Bug # 2650900.

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

3168: --
3169: -- 05-NOV-2002 Sacgupta Bug # 2650900.
3170: -- Removed the condition x_mode <> I. So now both Update process and
3171: -- Refresh process will fetch PA period name and GL period name from
3172: -- gl_date_period_map and related entities for inserting into
3173: -- pa_txn_accum table when GL and PA period name columns on rdl are null.
3174: --
3175: -- 07-Jul-2004 Sacgupta Bug # 3736097.
3176: -- Commented out all occurence of x_end_project_id.

Line 3243: gl_date_period_map p,

3239: SELECT
3240: p.period_name pa_period1,
3241: g.period_name gl_period1
3242: FROM
3243: gl_date_period_map p,
3244: gl_date_period_map g,
3245: pa_expenditures_all pe,
3246: pa_expenditure_types et,
3247: pa_expenditure_items_all ei,

Line 3244: gl_date_period_map g,

3240: p.period_name pa_period1,
3241: g.period_name gl_period1
3242: FROM
3243: gl_date_period_map p,
3244: gl_date_period_map g,
3245: pa_expenditures_all pe,
3246: pa_expenditure_types et,
3247: pa_expenditure_items_all ei,
3248: pa_cust_rev_dist_lines rdl,

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

3384: -- History
3385: -- dd-mmm-1997 Vbanal Created.
3386: --
3387: -- 15-OCT-2001 Jwhite Modified for the Enhanced Period Processing effort.
3388: -- Removed joins to gl_date_period_map and related entities
3389: -- and referenced new GL and PA period name columns on erdls
3390: --
3391: -- 13-OCT-2002 Sacgupta Bug # 2580808.
3392: -- Modified for the Enhanced Period Processing effort.

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

3389: -- and referenced new GL and PA period name columns on erdls
3390: --
3391: -- 13-OCT-2002 Sacgupta Bug # 2580808.
3392: -- Modified for the Enhanced Period Processing effort.
3393: -- Fetching PA period name and GL period name from gl_date_period_map
3394: -- and related entities for inserting into pa_txn_accum table when
3395: -- GL and PA period name columns on erdls are null.
3396: --
3397: -- 05-NOV-2002 Sacgupta Bug # 2650900.

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

3396: --
3397: -- 05-NOV-2002 Sacgupta Bug # 2650900.
3398: -- Removed the condition x_mode <> I. So now both Update process and
3399: -- Refresh process will fetch PA period name and GL period name from
3400: -- gl_date_period_map and related entities for inserting into
3401: -- pa_txn_accum table when GL and PA period name columns on erdls are null.
3402: --
3403: -- 07-JUL-2004 Sacgupta Bug # 3736097.
3404: -- Commented out all occurence of x_end_project_id.

Line 3462: gl_date_period_map p,

3458: SELECT
3459: p.period_name pa_period1,
3460: g.period_name gl_period1
3461: FROM
3462: gl_date_period_map p,
3463: gl_date_period_map g,
3464: pa_events ev,
3465: pa_event_types evt,
3466: pa_cust_event_rev_dist_lines erdl,

Line 3463: gl_date_period_map g,

3459: p.period_name pa_period1,
3460: g.period_name gl_period1
3461: FROM
3462: gl_date_period_map p,
3463: gl_date_period_map g,
3464: pa_events ev,
3465: pa_event_types evt,
3466: pa_cust_event_rev_dist_lines erdl,
3467: pa_draft_revenues dr,

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

3603: -- History
3604: -- dd-mmm-1997 Vbanal Created.
3605: --
3606: -- 15-OCT-2001 Jwhite Modified for the Enhanced Period Processing effort.
3607: -- Removed joins to gl_date_period_map and related entities
3608: -- and referenced new GL and PA period name columns.
3609: --
3610: -- 13-OCT-2002 Sacgupta Bug # 2580808.
3611: -- Modified for the Enhanced Period Processing effort.

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

3608: -- and referenced new GL and PA period name columns.
3609: --
3610: -- 13-OCT-2002 Sacgupta Bug # 2580808.
3611: -- Modified for the Enhanced Period Processing effort.
3612: -- Fetching PA period name and GL period name from gl_date_period_map
3613: -- and related entities for inserting into pa_txn_accum table when
3614: -- GL and PA period name columns on rdl are null.
3615: --
3616: -- 05-NOV-2002 Sacgupta Bug # 2650900.

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

3615: --
3616: -- 05-NOV-2002 Sacgupta Bug # 2650900.
3617: -- Removed the condition x_mode <> I. So now both Update process and
3618: -- Refresh process will fetch PA period name and GL period name from
3619: -- gl_date_period_map and related entities for inserting into
3620: -- pa_txn_accum table when GL and PA period name columns on rdl are null.
3621: --
3622: -- 07-JUL-2004 Sacgupta Bug # 3736097.
3623: -- Commented out all occurence of x_end_project_id.

Line 3741: gl_date_period_map p,

3737: SELECT
3738: p.period_name pa_period1,
3739: g.period_name gl_period1
3740: FROM
3741: gl_date_period_map p,
3742: gl_date_period_map g,
3743: pa_draft_revenues dr,
3744: pa_implementations pi,
3745: gl_sets_of_books sob

Line 3742: gl_date_period_map g,

3738: p.period_name pa_period1,
3739: g.period_name gl_period1
3740: FROM
3741: gl_date_period_map p,
3742: gl_date_period_map g,
3743: pa_draft_revenues dr,
3744: pa_implementations pi,
3745: gl_sets_of_books sob
3746: WHERE