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.

[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on PA_PERIOD_PROCESS_PKG

Line 1641: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1637: OR NVL(tmp.txn_raw_cost,0) <> 0
1638: OR NVL(tmp.txn_brdn_cost,0) <> 0
1639: OR NVL(tmp.txn_revenue,0) <> 0)
1640: AND pd.period_name = tmp.period_name
1641: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1642: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1643: AND pd.adjustment_period_flag = 'N'
1644: AND pd.start_date >= p_actual_from_date
1645: AND pd.start_date <= p_actual_to_date;

Line 1679: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1675: AND (NVL(tmp.quantity,0) <> 0
1676: OR NVL(tmp.txn_brdn_cost,0) <> 0
1677: OR NVL(tmp.txn_raw_cost,0) <> 0)
1678: AND pd.period_name = tmp.period_name
1679: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1680: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1681: AND pd.adjustment_period_flag = 'N'
1682: AND pd.start_date >= p_actual_from_date
1683: AND pd.start_date <= p_actual_to_date;

Line 1716: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1712: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711
1713: AND (NVL(tmp.quantity,0) <> 0
1714: OR NVL(tmp.txn_revenue,0) <> 0)
1715: AND pd.period_name = tmp.period_name
1716: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1717: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1718: AND pd.adjustment_period_flag = 'N'
1719: AND pd.start_date >= p_actual_from_date
1720: AND pd.start_date <= p_actual_to_date;

Line 1737: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1733: OR NVL(tmp.txn_raw_cost,0) <> 0
1734: OR NVL(tmp.txn_brdn_cost,0) <> 0
1735: OR NVL(tmp.txn_revenue,0) <> 0)
1736: AND pd.period_name = tmp.period_name
1737: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1738: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1739: AND pd.adjustment_period_flag = 'N'
1740: AND pd.start_date >= p_actual_from_date
1741: AND pd.start_date <= p_actual_to_date;

Line 1755: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1751: AND (NVL(tmp.quantity,0) <> 0
1752: OR NVL(tmp.txn_raw_cost,0) <> 0
1753: OR NVL(tmp.txn_brdn_cost,0) <> 0)
1754: AND pd.period_name = tmp.period_name
1755: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1756: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1757: AND pd.adjustment_period_flag = 'N'
1758: AND pd.start_date >= p_actual_from_date
1759: AND pd.start_date <= p_actual_to_date;

Line 1772: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1768: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711
1769: AND (NVL(tmp.quantity,0) <> 0
1770: OR NVL(tmp.txn_revenue,0) <> 0)
1771: AND pd.period_name = tmp.period_name
1772: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1773: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1774: AND pd.adjustment_period_flag = 'N'
1775: AND pd.start_date >= p_actual_from_date
1776: AND pd.start_date <= p_actual_to_date;

Line 2013: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id

2009: CURSOR gl_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
2010: SELECT start_date
2011: FROM gl_period_statuses
2012: WHERE period_name = c_period
2013: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id
2014: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
2015: AND adjustment_period_flag = 'N';
2016:
2017: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pvt.gen_average_of_actuals';

Line 2206: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id

2202: SELECT period_name, start_date, end_date
2203: BULK COLLECT
2204: INTO l_period_name_tab, l_start_date_tab, l_end_date_tab
2205: FROM gl_period_statuses
2206: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
2207: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
2208: AND adjustment_period_flag = 'N'
2209: AND start_date >= l_etc_from_date
2210: AND start_date <= least(p_planning_end_date,l_etc_to_date);