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_FP_WEBADI_PKG dependencies on GL_SETS_OF_BOOKS

Line 1888: gl_sets_of_books gsb

1884: gl.end_date end_date,
1885: gl.period_name period_name
1886: FROM gl_periods gl,
1887: pa_implementations_all pim,
1888: gl_sets_of_books gsb
1889: WHERE gl.end_date < c_first_prd_st_dt
1890: AND gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
1891: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)
1892: AND gl.adjustment_period_flag='N'

Line 1909: gl_sets_of_books gsb

1905: gl.end_date end_date,
1906: gl.period_name period_name
1907: FROM gl_periods gl,
1908: pa_implementations_all pim,
1909: gl_sets_of_books gsb
1910: WHERE gl.end_date > c_last_prd_en_dt
1911: AND gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
1912: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)
1913: AND gl.adjustment_period_flag='N'

Line 7131: gl_sets_of_books gsb

7127: SELECT gl.start_date
7128: INTO l_prd_mask_st_date_tbl(1)
7129: FROM gl_periods gl,
7130: pa_implementations_all pim,
7131: gl_sets_of_books gsb
7132: WHERE pim.org_id = p_version_info_rec.x_org_id
7133: AND gsb.set_of_books_id = pim.set_of_books_id
7134: AND gl.period_set_name= DECODE(p_version_info_rec.x_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
7135: AND gl.period_type = DECODE(p_version_info_rec.x_time_phased_code,

Line 7146: gl_sets_of_books gsb

7142: SELECT gl.end_date
7143: INTO l_prd_mask_end_date_tbl(l_prd_mask_end_date_tbl.COUNT)
7144: FROM gl_periods gl,
7145: pa_implementations_all pim,
7146: gl_sets_of_books gsb
7147: WHERE pim.org_id = p_version_info_rec.x_org_id
7148: AND gsb.set_of_books_id = pim.set_of_books_id
7149: AND gl.period_set_name= DECODE(p_version_info_rec.x_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
7150: AND gl.period_type = DECODE(p_version_info_rec.x_time_phased_code,

Line 10238: gl_sets_of_books gsb

10234: gl.period_set_name period_set_name,
10235: gl.period_type period_type
10236: FROM gl_periods gl,
10237: pa_implementations_all pim,
10238: gl_sets_of_books gsb
10239: WHERE gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
10240: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)
10241: AND gl.adjustment_period_flag='N'
10242: AND pim.org_id = c_org_id

Line 10253: gl_sets_of_books gsb

10249: gl.period_set_name period_set_name,
10250: gl.period_type period_type
10251: FROM gl_periods gl,
10252: pa_implementations_all pim,
10253: gl_sets_of_books gsb
10254: WHERE gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
10255: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)
10256: AND gl.adjustment_period_flag='N'
10257: AND pim.org_id = c_org_id

Line 10268: gl_sets_of_books gsb

10264: gl.period_set_name period_set_name,
10265: gl.period_type period_type
10266: FROM gl_periods gl,
10267: pa_implementations_all pim,
10268: gl_sets_of_books gsb
10269: WHERE gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
10270: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)
10271: AND gl.adjustment_period_flag='N'
10272: AND pim.org_id = c_org_id

Line 11604: c_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE,

11600: WHERE org_id = c_org_id;
11601:
11602: --This Cursor is used to get period information based on the Time Phasing of the budget version.
11603: CURSOR period_grouping_cur(c_period_set_name gl_periods.period_set_name%TYPE,
11604: c_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE,
11605: c_org_id pa_implementations_all.org_id%TYPE,
11606: c_pa_period_type pa_implementations_all.pa_period_type%TYPE,
11607: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)
11608: IS

Line 11618: gl_sets_of_books gsb

11614: gl.period_set_name period_set_name,
11615: gsb.accounted_period_type accounted_period_type,
11616: c_org_id
11617: FROM gl_periods gl,
11618: gl_sets_of_books gsb
11619: WHERE gl.period_set_name=decode(c_time_phased_code,'P',c_period_set_name,'G',gsb.period_set_name)
11620: AND gsb.set_of_books_id=c_set_of_books_id
11621: AND gl.ADJUSTMENT_PERIOD_FLAG ='N'
11622: AND gl.period_type = decode(c_time_phased_code,'P',c_pa_period_type,