DBA Data[Home] [Help]

APPS.PA_REPORT_UTIL dependencies on PA_PERIODS_V

Line 319: FROM pa_periods_v paperiod,

315: SELECT paperiod.period_name,
316: paperiod.period_year,
317: paperiod.status_meaning
318: INTO l_prd_name,l_prd_yr,l_meaning
319: FROM pa_periods_v paperiod,
320: pa_implementations imp,
321: gl_period_statuses glpersts
322: WHERE glpersts.period_type = imp.pa_period_type
323: AND imp.set_of_books_id = paperiod.set_of_books_id

Line 998: FROM pa_periods_v paperiod,

994: paperiod.status,
995: paperiod.quarter_num,
996: glpersts.effective_period_num,
997: paperiod.status_meaning
998: FROM pa_periods_v paperiod,
999: pa_implementations imp,
1000: gl_period_statuses glpersts
1001: WHERE glpersts.period_type = imp.pa_period_type
1002: AND imp.set_of_books_id = paperiod.set_of_books_id

Line 1270: FROM pa_periods_v paperiod,

1266: paperiod.quarter_num,
1267: glpersts.effective_period_num,
1268: paperiod.status_meaning
1269: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1270: FROM pa_periods_v paperiod,
1271: pa_implementations imp,
1272: gl_period_statuses glpersts
1273: WHERE glpersts.period_type = imp.pa_period_type
1274: AND imp.set_of_books_id = paperiod.set_of_books_id

Line 1458: FROM pa_periods_v paperiod,

1454: paperiod.quarter_num,
1455: glpersts.effective_period_num,
1456: paperiod.status_meaning
1457: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1458: FROM pa_periods_v paperiod,
1459: pa_implementations imp,
1460: gl_period_statuses glpersts
1461: WHERE glpersts.period_type = imp.pa_period_type
1462: AND imp.set_of_books_id = paperiod.set_of_books_id