APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_PERIOD_QUOTAS_EXT_ALL

Line 910: from cn_srp_period_quotas_ext_all

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

Line 942: FROM cn_srp_period_quotas_ext_all

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

Line 1012: update cn_srp_period_quotas_ext_all

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

Line 1048: update cn_srp_period_quotas_ext_all

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