APPS.PA_FP_REV_GEN_PUB dependencies on PA_FIN_PLAN_TYPES_B

Line 53: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;

49: l_running_txn_rev NUMBER := 0;
50: l_running_pc_rev NUMBER := 0;
51: l_ratio NUMBER;
52:
53: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
54: l_init_rev_sum PA_BUDGET_LINES.INIT_REVENUE%TYPE := 0;
55: l_pc_init_rev_sum PA_BUDGET_LINES.PROJECT_INIT_REVENUE%TYPE := 0;
56: l_burdened_cost_sum PA_BUDGET_LINES.BURDENED_COST%TYPE;
57:

Line 163: PA_FIN_PLAN_TYPES_B fpt

159:
160: SELECT fpt.PLAN_CLASS_CODE
161: INTO l_plan_class_code
162: FROM PA_BUDGET_VERSIONS bv,
163: PA_FIN_PLAN_TYPES_B fpt
164: WHERE bv.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
165: AND bv.fin_plan_type_id = fpt.fin_plan_type_id;
166:
167: IF p_pa_debug_mode = 'Y' THEN

Line 1620: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,

1616: PROCEDURE PUSH_RES_SCH_DATA_TO_BL
1617: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1618: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1619: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
1620: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
1621: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1622: X_MSG_COUNT OUT NOCOPY NUMBER,
1623: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1624: