APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_SRP_PERIOD_QUOTAS_EXT_ALL

Line 621: FROM cn_srp_period_quotas_ext_all

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

Line 755: UPDATE cn_srp_period_quotas_ext_all

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

Line 956: UPDATE cn_srp_period_quotas_ext_all

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