APPS.PA_FP_GEN_PUB dependencies on PA_PERIODS_ALL

Line 1091: FROM pa_periods_all pap

1087: SELECT pap.start_date,
1088: pap.end_date
1089: INTO l_start_date,
1090: l_end_date
1091: FROM pa_periods_all pap
1092: WHERE pap.period_name = p_unspent_amt_period
1093: AND pap.org_id = p_fp_cols_rec.x_org_id;
1094: EXCEPTION
1095: WHEN OTHERS THEN RAISE;

Line 1579: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

1575: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
1576: P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1577: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1578: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1579: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1580: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1581: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1582: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1583: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,

Line 1614: CURSOR pa_period_csr(c_amt_thru PA_PERIODS_ALL.END_DATE%TYPE,

1610: l_pc_burdened_cost NUMBER;
1611: l_pc_revenue NUMBER;
1612:
1613: --Cursor used to select the PA period that contains the amts_thru_date and later
1614: CURSOR pa_period_csr(c_amt_thru PA_PERIODS_ALL.END_DATE%TYPE,
1615: c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE) IS
1616: SELECT period_name, start_date, end_date
1617: FROM pa_periods_all
1618: WHERE org_id = c_org_id and -- R12 MOAC 4447573: nvl(org_id,-99) = nvl(c_org_id,-99)

Line 1617: FROM pa_periods_all

1613: --Cursor used to select the PA period that contains the amts_thru_date and later
1614: CURSOR pa_period_csr(c_amt_thru PA_PERIODS_ALL.END_DATE%TYPE,
1615: c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE) IS
1616: SELECT period_name, start_date, end_date
1617: FROM pa_periods_all
1618: WHERE org_id = c_org_id and -- R12 MOAC 4447573: nvl(org_id,-99) = nvl(c_org_id,-99)
1619: c_amt_thru between start_date and end_date;
1620: pa_period_rec pa_period_csr%ROWTYPE;
1621:

Line 1623: CURSOR gl_period_csr(c_amt_thru PA_PERIODS_ALL.END_DATE%TYPE,

1619: c_amt_thru between start_date and end_date;
1620: pa_period_rec pa_period_csr%ROWTYPE;
1621:
1622: --Cursor used to select the GL period that contains the amts_thru_date and later
1623: CURSOR gl_period_csr(c_amt_thru PA_PERIODS_ALL.END_DATE%TYPE,
1624: c_set_of_books PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE) IS
1625: SELECT period_name, start_date , end_date
1626: FROM gl_period_statuses
1627: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id and