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.PSB_BUDGET_REVISIONS_PVT dependencies on GL_PERIOD_STATUSES

Line 717: from gl_period_statuses

713: where set_of_books_id = g_set_of_books_id;
714:
715: cursor c_gl_dates is
716: select period_name, start_date,end_date
717: from gl_period_statuses
718: where application_id = 101
719: and set_of_books_id = g_set_of_books_id
720: and period_name in (g_from_gl_period_name, g_to_gl_period_name);
721:

Line 724: from GL_PERIOD_STATUSES

720: and period_name in (g_from_gl_period_name, g_to_gl_period_name);
721:
722: cursor c_gl_dates_br is
723: select min(start_date) start_date, max(end_date) end_date
724: from GL_PERIOD_STATUSES
725: where application_id = 101
726: and set_of_books_id = g_set_of_books_id
727: and period_name in
728: (select b.gl_period_name from psb_budget_revision_lines a, psb_budget_revision_accounts b

Line 954: FROM gl_period_statuses

950: --
951: CURSOR l_gl_dates_csr
952: IS
953: SELECT start_date, end_date
954: FROM gl_period_statuses
955: WHERE application_id = 101
956: AND set_of_books_id = g_set_of_books_id
957: AND period_name = p_gl_period_name;
958: --

Line 1867: from gl_period_statuses

1863: and NVL(pbra.currency_code,p_currency_code)
1864: = NVL(pbr.currency_code,p_currency_code) -- Bug 3029168
1865: and pbra.gl_period_name in
1866: (select period_name
1867: from gl_period_statuses
1868: where application_id = 101
1869: and set_of_books_id = p_set_of_books_id
1870: and start_date between l_from_date and l_to_date
1871: and end_date between l_from_date and l_to_date);

Line 1875: from gl_period_statuses

1871: and end_date between l_from_date and l_to_date);
1872:
1873: Cursor c_gl_dates is
1874: Select period_name, start_date,end_date
1875: from gl_period_statuses
1876: where application_id = 101
1877: and set_of_books_id = p_set_of_books_id
1878: and period_name in (p_gl_period, p_end_gl_period);
1879:

Line 2174: GL_PERIOD_STATUSES gps

2170: pbra.revision_type,
2171: pbra.revision_value_type,
2172: pbra.revision_amount
2173: from psb_budget_revision_accounts_v pbra,
2174: GL_PERIOD_STATUSES gps
2175: where budget_revision_id = p_budget_revision_id
2176: and gps.application_id = 101
2177: and gps.set_of_books_id = g_set_of_books_id
2178: and gps.period_name = pbra.gl_period_name;

Line 3144: from gl_period_statuses

3140:
3141: cursor c_gl_periods is
3142: Select period_name,
3143: start_date,end_date
3144: from gl_period_statuses
3145: where application_id = 101
3146: and set_of_books_id = g_set_of_books_id
3147: and start_date between g_from_date and g_to_date
3148: and end_date between g_from_date and g_to_date

Line 3220: from gl_period_statuses

3216:
3217: cursor c_period_list is
3218: Select period_name,
3219: start_date,end_date
3220: from gl_period_statuses
3221: where application_id = 101
3222: and set_of_books_id = g_set_of_books_id
3223: and start_date between g_effective_start_date and g_effective_end_date
3224: and end_date between g_effective_start_date and g_effective_end_date

Line 3234: from gl_period_statuses

3230: cursor c_period (startdate DATE) is
3231: select period_name,
3232: start_date,
3233: end_date
3234: from gl_period_statuses
3235: where application_id = 101
3236: and set_of_books_id = g_set_of_books_id
3237: and startdate between start_date and end_date;
3238:

Line 5362: from gl_period_statuses

5358: l_msg_data VARCHAR2(2000);
5359:
5360: cursor c_gl_period is
5361: select period_name
5362: from gl_period_statuses
5363: where application_id = 101
5364: and set_of_books_id = g_set_of_books_id
5365: and p_effective_start_date between start_date and end_date;
5366:

Line 6501: FROM gl_period_statuses

6497: );
6498: --
6499: CURSOR c_period IS
6500: SELECT period_name, start_date, end_date
6501: FROM gl_period_statuses
6502: WHERE application_id = 101
6503: AND set_of_books_id = g_set_of_books_id
6504: AND p_revision_start_date BETWEEN start_date AND end_date;
6505: --

Line 7421: from gl_period_statuses

7417: and pbr.budget_group_id = g_budget_group_id
7418: and pbr.base_line_revision = 'Y'
7419: and pbra.gl_period_name in
7420: (select period_name
7421: from gl_period_statuses
7422: where application_id = 101
7423: and set_of_books_id = g_set_of_books_id
7424: and start_date between g_from_date and g_to_date
7425: and end_date between g_from_date and g_to_date);

Line 7448: from gl_period_statuses

7444: and pbr.budget_group_id = g_budget_group_id
7445: and pbr.base_line_revision = 'Y'
7446: and pbra.gl_period_name in
7447: (select period_name
7448: from gl_period_statuses
7449: where application_id = 101
7450: and set_of_books_id = g_set_of_books_id
7451: and start_date between g_from_date and g_to_date
7452: and end_date between g_from_date and g_to_date);