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 1892: gl_sets_of_books gsb

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

Line 1913: gl_sets_of_books gsb

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

Line 7262: gl_sets_of_books gsb

7258: SELECT gl.start_date
7259: INTO l_prd_mask_st_date_tbl(1)
7260: FROM gl_periods gl,
7261: pa_implementations_all pim,
7262: gl_sets_of_books gsb
7263: WHERE pim.org_id = p_version_info_rec.x_org_id
7264: AND gsb.set_of_books_id = pim.set_of_books_id
7265: AND gl.period_set_name= DECODE(p_version_info_rec.x_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
7266: AND gl.period_type = DECODE(p_version_info_rec.x_time_phased_code,

Line 7277: gl_sets_of_books gsb

7273: SELECT gl.end_date
7274: INTO l_prd_mask_end_date_tbl(l_prd_mask_end_date_tbl.COUNT)
7275: FROM gl_periods gl,
7276: pa_implementations_all pim,
7277: gl_sets_of_books gsb
7278: WHERE pim.org_id = p_version_info_rec.x_org_id
7279: AND gsb.set_of_books_id = pim.set_of_books_id
7280: AND gl.period_set_name= DECODE(p_version_info_rec.x_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
7281: AND gl.period_type = DECODE(p_version_info_rec.x_time_phased_code,

Line 10419: gl_sets_of_books gsb

10415: gl.period_set_name period_set_name,
10416: gl.period_type period_type
10417: FROM gl_periods gl,
10418: pa_implementations_all pim,
10419: gl_sets_of_books gsb
10420: WHERE gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
10421: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)
10422: AND gl.adjustment_period_flag='N'
10423: AND pim.org_id = c_org_id

Line 10434: gl_sets_of_books gsb

10430: gl.period_set_name period_set_name,
10431: gl.period_type period_type
10432: FROM gl_periods gl,
10433: pa_implementations_all pim,
10434: gl_sets_of_books gsb
10435: WHERE gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
10436: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)
10437: AND gl.adjustment_period_flag='N'
10438: AND pim.org_id = c_org_id

Line 10449: gl_sets_of_books gsb

10445: gl.period_set_name period_set_name,
10446: gl.period_type period_type
10447: FROM gl_periods gl,
10448: pa_implementations_all pim,
10449: gl_sets_of_books gsb
10450: WHERE gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
10451: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)
10452: AND gl.adjustment_period_flag='N'
10453: AND pim.org_id = c_org_id

Line 11835: c_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE,

11831: WHERE org_id = c_org_id;
11832:
11833: --This Cursor is used to get period information based on the Time Phasing of the budget version.
11834: CURSOR period_grouping_cur(c_period_set_name gl_periods.period_set_name%TYPE,
11835: c_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE,
11836: c_org_id pa_implementations_all.org_id%TYPE,
11837: c_pa_period_type pa_implementations_all.pa_period_type%TYPE,
11838: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)
11839: IS

Line 11849: gl_sets_of_books gsb

11845: gl.period_set_name period_set_name,
11846: gsb.accounted_period_type accounted_period_type,
11847: c_org_id
11848: FROM gl_periods gl,
11849: gl_sets_of_books gsb
11850: WHERE gl.period_set_name=decode(c_time_phased_code,'P',c_period_set_name,'G',gsb.period_set_name)
11851: AND gsb.set_of_books_id=c_set_of_books_id
11852: AND gl.ADJUSTMENT_PERIOD_FLAG ='N'
11853: AND gl.period_type = decode(c_time_phased_code,'P',c_pa_period_type,