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 1891: pa_implementations_all pim,

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

Line 1912: pa_implementations_all pim,

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

Line 7261: pa_implementations_all pim,

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

Line 7276: pa_implementations_all pim,

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

Line 10418: pa_implementations_all pim,

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

Line 10433: pa_implementations_all pim,

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

Line 10448: pa_implementations_all pim,

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

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

11820: ORDER BY pmd.from_anchor_position;
11821: --PL/SQL table created based on Cursor period_mask_cur.
11822: TYPE period_mask_tbl IS TABLE OF period_mask_cur%ROWTYPE;
11823:
11824: CURSOR pa_impl_cur(c_org_id pa_implementations_all.org_id%TYPE)
11825: IS
11826: SELECT org_id,
11827: period_set_name,
11828: pa_period_type,

Line 11830: FROM pa_implementations_all

11826: SELECT org_id,
11827: period_set_name,
11828: pa_period_type,
11829: set_of_books_id
11830: FROM pa_implementations_all
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,

Line 11836: c_org_id pa_implementations_all.org_id%TYPE,

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

Line 11837: c_pa_period_type pa_implementations_all.pa_period_type%TYPE,

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