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 PA_IMPLEMENTATIONS_ALL

Line 1887: pa_implementations_all pim,

1883: SELECT gl.start_date start_date,
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)

Line 1908: pa_implementations_all pim,

1904: SELECT gl.start_date start_date,
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)

Line 7130: pa_implementations_all pim,

7126: --log1('----- STAGE X3.6------- '|| p_planning_end_date_tbl(l_bl_index));
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)

Line 7145: pa_implementations_all pim,

7141:
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)

Line 10237: pa_implementations_all pim,

10233: gl.period_name period_name,
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'

Line 10252: pa_implementations_all pim,

10248: gl.period_name period_name,
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'

Line 10267: pa_implementations_all pim,

10263: gl.period_name period_name,
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'

Line 11593: CURSOR pa_impl_cur(c_org_id pa_implementations_all.org_id%TYPE)

11589: ORDER BY pmd.from_anchor_position;
11590: --PL/SQL table created based on Cursor period_mask_cur.
11591: TYPE period_mask_tbl IS TABLE OF period_mask_cur%ROWTYPE;
11592:
11593: CURSOR pa_impl_cur(c_org_id pa_implementations_all.org_id%TYPE)
11594: IS
11595: SELECT org_id,
11596: period_set_name,
11597: pa_period_type,

Line 11599: FROM pa_implementations_all

11595: SELECT org_id,
11596: period_set_name,
11597: pa_period_type,
11598: set_of_books_id
11599: FROM pa_implementations_all
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,

Line 11605: c_org_id pa_implementations_all.org_id%TYPE,

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
11609: SELECT ROW_NUMBER() OVER( PARTITION BY gl.period_set_name,gl.period_type ORDER BY gl.start_date ) row_num,

Line 11606: c_pa_period_type pa_implementations_all.pa_period_type%TYPE,

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
11609: SELECT ROW_NUMBER() OVER( PARTITION BY gl.period_set_name,gl.period_type ORDER BY gl.start_date ) row_num,
11610: gl.start_date start_date,