[Home] [Help]
1627: x_txn_amt_rec.txn_raw_cost_sum,
1628: x_txn_amt_rec.txn_burdened_cost_sum,
1629: x_txn_amt_rec.txn_revenue_sum
1630: FROM PA_FP_FCST_GEN_TMP1 tmp,
1631: gl_period_statuses pd
1632: WHERE tmp.data_type_code = 'TARGET_FP'
1633: AND tmp.project_element_id = P_TASK_ID
1634: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1635: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711
1666: x_txn_amt_rec.txn_raw_cost_sum,
1667: x_txn_amt_rec.txn_burdened_cost_sum,
1668: x_txn_amt_rec.txn_revenue_sum
1669: FROM PA_FP_FCST_GEN_TMP1 tmp,
1670: gl_period_statuses pd
1671: WHERE tmp.data_type_code = 'TARGET_FP'
1672: AND tmp.project_element_id = P_TASK_ID
1673: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1674: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711
1704: x_txn_amt_rec.txn_raw_cost_sum,
1705: x_txn_amt_rec.txn_burdened_cost_sum,
1706: x_txn_amt_rec.txn_revenue_sum
1707: FROM PA_FP_FCST_GEN_TMP1 tmp,
1708: gl_period_statuses pd
1709: WHERE tmp.data_type_code = 'TARGET_FP'
1710: AND tmp.project_element_id = P_TASK_ID
1711: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1712: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711
1723: IF P_FP_COLS_REC.x_version_type = 'ALL' THEN
1724: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1725: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1726: FROM PA_FP_FCST_GEN_TMP1 tmp,
1727: gl_period_statuses pd
1728: WHERE tmp.data_type_code = 'TARGET_FP'
1729: AND tmp.project_element_id = P_TASK_ID
1730: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1731: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711
1742: ELSIF P_FP_COLS_REC.x_version_type = 'COST' THEN
1743: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1744: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1745: FROM PA_FP_FCST_GEN_TMP1 tmp,
1746: gl_period_statuses pd
1747: WHERE tmp.data_type_code = 'TARGET_FP'
1748: AND tmp.project_element_id = P_TASK_ID
1749: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1750: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711
1760: ELSIF P_FP_COLS_REC.x_version_type = 'REVENUE' THEN
1761: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1762: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1763: FROM PA_FP_FCST_GEN_TMP1 tmp,
1764: gl_period_statuses pd
1765: WHERE tmp.data_type_code = 'TARGET_FP'
1766: AND tmp.project_element_id = P_TASK_ID
1767: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1768: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711
2007:
2008: --Cursor used to select the start_date for GL periods
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';
2201: ELSIF p_fp_cols_rec.x_time_phased_code ='G' THEN
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