APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_SRP_PERIOD_QUOTAS_EXT_ALL

Line 623: FROM cn_srp_period_quotas_ext_all

619: CURSOR periods_ext(p_srp_period_quota_id NUMBER) IS
620: SELECT nvl(input_achieved_ptd, 0) input_achieved_ptd,
621: nvl(input_achieved_itd, 0) input_achieved_itd,
622: input_sequence
623: FROM cn_srp_period_quotas_ext_all
624: WHERE srp_period_quota_id = p_srp_period_quota_id
625: ORDER BY input_sequence;
626:
627: comm_bonus comm_bonus_cr%ROWTYPE;

Line 757: UPDATE cn_srp_period_quotas_ext_all

753: AND srp_plan_assign_id = p_srp_pe_subledger.srp_plan_assign_id
754: returning srp_period_quota_id INTO l_srp_period_quota_id;
755:
756: FOR i IN 2 .. p_srp_pe_subledger.input_ptd.COUNT LOOP
757: UPDATE cn_srp_period_quotas_ext_all
758: SET input_achieved_ptd = p_srp_pe_subledger.input_ptd(i) ,
759: input_achieved_itd = p_srp_pe_subledger.input_itd(i) ,
760: last_update_date = Sysdate,
761: last_updated_by = fnd_global.user_id,

Line 958: UPDATE cn_srp_period_quotas_ext_all

954:
955: FOR period_ext IN periods_ext(period.srp_period_quota_id) LOOP
956: l_input_achieved_itd_tbl(period_ext.input_sequence) := l_input_achieved_itd_tbl(period_ext.input_sequence) + period_ext.input_achieved_ptd;
957:
958: UPDATE cn_srp_period_quotas_ext_all
959: SET input_achieved_itd = l_input_achieved_itd_tbl(period_ext.input_sequence),
960: LAST_UPDATE_DATE = sysdate,
961: LAST_UPDATED_BY = fnd_global.user_id,
962: LAST_UPDATE_LOGIN = fnd_global.login_id