APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_PERIOD_QUOTAS_EXT_ALL

Line 909: from cn_srp_period_quotas_ext_all

905: CURSOR other_inputs IS
906: select input_sequence,
907: input_achieved_itd,
908: input_achieved_ptd
909: from cn_srp_period_quotas_ext_all
910: where srp_period_quota_id = (select srp_period_quota_id
911: from cn_srp_period_quotas_all
912: where srp_plan_assign_id = p_srp_plan_assign_id
913: and quota_id = p_quota_id

Line 941: FROM cn_srp_period_quotas_ext_all

937: CURSOR periods_ext(p_srp_period_quota_id NUMBER) IS
938: SELECT nvl(input_achieved_ptd, 0) input_achieved_ptd,
939: nvl(input_achieved_itd, 0) input_achieved_itd,
940: input_sequence
941: FROM cn_srp_period_quotas_ext_all
942: WHERE srp_period_quota_id = p_srp_period_quota_id
943: ORDER BY input_sequence;
944:
945: BEGIN

Line 1011: update cn_srp_period_quotas_ext_all

1007: l_recovery_amount_itd,
1008: l_comm_pend_itd;
1009:
1010: if (SQL%found) then
1011: update cn_srp_period_quotas_ext_all
1012: set input_achieved_itd = input_achieved_ptd
1013: where srp_period_quota_id = l_srp_period_quota_id;
1014:
1015: for period_ext in periods_ext(l_srp_period_quota_id) loop

Line 1047: update cn_srp_period_quotas_ext_all

1043: for period_ext in periods_ext(period.srp_period_quota_id) loop
1044: l_input_achieved_itd_tbl(period_ext.input_sequence) :=
1045: l_input_achieved_itd_tbl(period_ext.input_sequence) + period_ext.input_achieved_ptd;
1046:
1047: update cn_srp_period_quotas_ext_all
1048: set input_achieved_itd = l_input_achieved_itd_tbl(period_ext.input_sequence),
1049: LAST_UPDATE_DATE = sysdate,
1050: LAST_UPDATED_BY = fnd_global.user_id,
1051: LAST_UPDATE_LOGIN = fnd_global.login_id