APPS.CN_CALC_FORMULAS_PVT dependencies on CN_SRP_PERIOD_QUOTAS_EXT_S

Line 611: l_srp_prd_quota_ext_id cn_srp_period_quotas_ext.srp_period_quota_ext_id%TYPE;

607: l_api_name CONSTANT VARCHAR2(30) := 'Update_Formula';
608: l_api_version CONSTANT NUMBER := 1.0;
609: l_temp_id NUMBER;
610: l_update_count NUMBER := 0;
611: l_srp_prd_quota_ext_id cn_srp_period_quotas_ext.srp_period_quota_ext_id%TYPE;
612: l_num_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
613: l_count_formula_input NUMBER := 0;
614: l_plan_elt_tbl CN_CALC_SQL_EXPS_PVT.NUM_TBL_TYPE;
615:

Line 653: SELECT cn_srp_period_quotas_ext_s.NEXTVAL

649: l_old_rec get_old_formula_rec%ROWTYPE;
650: /* End - R12 Notes History */
651:
652: CURSOR c_next_srp_qut_id IS
653: SELECT cn_srp_period_quotas_ext_s.NEXTVAL
654: FROM dual;
655:
656: CURSOR c_srp_quota_detail IS
657: select spq.srp_period_quota_id