APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on PA_PERIOD_PROCESS_PKG

Line 1619: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1615: OR NVL(tmp.txn_raw_cost,0) <> 0
1616: OR NVL(tmp.txn_brdn_cost,0) <> 0
1617: OR NVL(tmp.txn_revenue,0) <> 0)
1618: AND pd.period_name = tmp.period_name
1619: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1620: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1621: AND pd.adjustment_period_flag = 'N'
1622: AND pd.start_date >= p_actual_from_date
1623: AND pd.start_date <= p_actual_to_date;

Line 1656: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1652: AND (NVL(tmp.quantity,0) <> 0
1653: OR NVL(tmp.txn_brdn_cost,0) <> 0
1654: OR NVL(tmp.txn_raw_cost,0) <> 0)
1655: AND pd.period_name = tmp.period_name
1656: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1657: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1658: AND pd.adjustment_period_flag = 'N'
1659: AND pd.start_date >= p_actual_from_date
1660: AND pd.start_date <= p_actual_to_date;

Line 1692: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1688: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1689: AND (NVL(tmp.quantity,0) <> 0
1690: OR NVL(tmp.txn_revenue,0) <> 0)
1691: AND pd.period_name = tmp.period_name
1692: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1693: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1694: AND pd.adjustment_period_flag = 'N'
1695: AND pd.start_date >= p_actual_from_date
1696: AND pd.start_date <= p_actual_to_date;

Line 1712: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1708: OR NVL(tmp.txn_raw_cost,0) <> 0
1709: OR NVL(tmp.txn_brdn_cost,0) <> 0
1710: OR NVL(tmp.txn_revenue,0) <> 0)
1711: AND pd.period_name = tmp.period_name
1712: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1713: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1714: AND pd.adjustment_period_flag = 'N'
1715: AND pd.start_date >= p_actual_from_date
1716: AND pd.start_date <= p_actual_to_date;

Line 1729: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1725: AND (NVL(tmp.quantity,0) <> 0
1726: OR NVL(tmp.txn_raw_cost,0) <> 0
1727: OR NVL(tmp.txn_brdn_cost,0) <> 0)
1728: AND pd.period_name = tmp.period_name
1729: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1730: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1731: AND pd.adjustment_period_flag = 'N'
1732: AND pd.start_date >= p_actual_from_date
1733: AND pd.start_date <= p_actual_to_date;

Line 1745: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

1741: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1742: AND (NVL(tmp.quantity,0) <> 0
1743: OR NVL(tmp.txn_revenue,0) <> 0)
1744: AND pd.period_name = tmp.period_name
1745: AND pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
1746: AND pd.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1747: AND pd.adjustment_period_flag = 'N'
1748: AND pd.start_date >= p_actual_from_date
1749: AND pd.start_date <= p_actual_to_date;

Line 1982: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id

1978: CURSOR gl_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
1979: SELECT start_date
1980: FROM gl_period_statuses
1981: WHERE period_name = c_period
1982: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id
1983: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1984: AND adjustment_period_flag = 'N';
1985:
1986: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pvt.gen_average_of_actuals';

Line 2173: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id

2169: SELECT period_name, start_date, end_date
2170: BULK COLLECT
2171: INTO l_period_name_tab, l_start_date_tab, l_end_date_tab
2172: FROM gl_period_statuses
2173: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
2174: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
2175: AND adjustment_period_flag = 'N'
2176: AND start_date >= l_etc_from_date
2177: AND start_date <= least(p_planning_end_date,l_etc_to_date);