APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on GL_PERIOD_STATUSES

Line 1610: gl_period_statuses pd

1606: x_txn_amt_rec.txn_raw_cost_sum,
1607: x_txn_amt_rec.txn_burdened_cost_sum,
1608: x_txn_amt_rec.txn_revenue_sum
1609: FROM PA_FP_FCST_GEN_TMP1 tmp,
1610: gl_period_statuses pd
1611: WHERE tmp.data_type_code = 'TARGET_FP'
1612: AND tmp.project_element_id = P_TASK_ID
1613: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1614: AND (NVL(tmp.quantity,0) <> 0

Line 1648: gl_period_statuses pd

1644: x_txn_amt_rec.txn_raw_cost_sum,
1645: x_txn_amt_rec.txn_burdened_cost_sum,
1646: x_txn_amt_rec.txn_revenue_sum
1647: FROM PA_FP_FCST_GEN_TMP1 tmp,
1648: gl_period_statuses pd
1649: WHERE tmp.data_type_code = 'TARGET_FP'
1650: AND tmp.project_element_id = P_TASK_ID
1651: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1652: AND (NVL(tmp.quantity,0) <> 0

Line 1685: gl_period_statuses pd

1681: x_txn_amt_rec.txn_raw_cost_sum,
1682: x_txn_amt_rec.txn_burdened_cost_sum,
1683: x_txn_amt_rec.txn_revenue_sum
1684: FROM PA_FP_FCST_GEN_TMP1 tmp,
1685: gl_period_statuses pd
1686: WHERE tmp.data_type_code = 'TARGET_FP'
1687: AND tmp.project_element_id = P_TASK_ID
1688: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1689: AND (NVL(tmp.quantity,0) <> 0

Line 1703: gl_period_statuses pd

1699: IF P_FP_COLS_REC.x_version_type = 'ALL' THEN
1700: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1701: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1702: FROM PA_FP_FCST_GEN_TMP1 tmp,
1703: gl_period_statuses pd
1704: WHERE tmp.data_type_code = 'TARGET_FP'
1705: AND tmp.project_element_id = P_TASK_ID
1706: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1707: AND (NVL(tmp.quantity,0) <> 0

Line 1721: gl_period_statuses pd

1717: ELSIF P_FP_COLS_REC.x_version_type = 'COST' THEN
1718: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1719: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1720: FROM PA_FP_FCST_GEN_TMP1 tmp,
1721: gl_period_statuses pd
1722: WHERE tmp.data_type_code = 'TARGET_FP'
1723: AND tmp.project_element_id = P_TASK_ID
1724: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1725: AND (NVL(tmp.quantity,0) <> 0

Line 1738: gl_period_statuses pd

1734: ELSIF P_FP_COLS_REC.x_version_type = 'REVENUE' THEN
1735: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1736: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1737: FROM PA_FP_FCST_GEN_TMP1 tmp,
1738: gl_period_statuses pd
1739: WHERE tmp.data_type_code = 'TARGET_FP'
1740: AND tmp.project_element_id = P_TASK_ID
1741: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1742: AND (NVL(tmp.quantity,0) <> 0

Line 1980: FROM gl_period_statuses

1976:
1977: --Cursor used to select the start_date for GL periods
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';

Line 2172: FROM gl_period_statuses

2168: ELSIF p_fp_cols_rec.x_time_phased_code ='G' THEN
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