APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_SRP_PERIOD_QUOTAS_ALL

Line 15: cn_srp_period_quotas_all cspq

11: BEGIN
12: SELECT max(p2.cal_period_id)
13: INTO l_max_period_id
14: FROM cn_cal_per_int_types_all p2,
15: cn_srp_period_quotas_all cspq
16: WHERE p2.interval_type_id = (select interval_type_id
17: from cn_quotas_all
18: where quota_id = p_quota_id)
19: AND p2.interval_number = (select p1.interval_number

Line 611: FROM cn_srp_period_quotas_all spq

607: Nvl(spq.advance_recovered_itd,0) advance_recovered_itd ,
608: Nvl(spq.advance_to_rec_itd,0) advance_to_rec_itd,
609: Nvl(spq.recovery_amount_itd,0) recovery_amount_itd,
610: Nvl(spq.comm_pend_itd,0)comm_pend_itd
611: FROM cn_srp_period_quotas_all spq
612: WHERE salesrep_id = p_srp_pe_subledger.salesrep_id
613: AND period_id >= p_srp_pe_subledger.accu_period_id
614: AND quota_id = p_srp_pe_subledger.quota_id
615: AND srp_plan_assign_id = p_srp_pe_subledger.srp_plan_assign_id

Line 705: UPDATE cn_srp_period_quotas_all

701:
702: IF p_mode = 'A' THEN
703:
704: -- All Columns need to be updated
705: UPDATE cn_srp_period_quotas_all
706: SET input_achieved_ptd = p_srp_pe_subledger.input_ptd(1) ,
707: input_achieved_itd = p_srp_pe_subledger.input_itd(1) ,
708:
709: output_achieved_ptd = p_srp_pe_subledger.output_ptd ,

Line 771: UPDATE cn_srp_period_quotas_all

767: ELSE
768:
769: -- Update only commission related columns
770:
771: UPDATE cn_srp_period_quotas_all
772: SET
773: transaction_amount_ptd = Nvl(comm_bonus.transaction_amount_ptd,0),
774: transaction_amount_itd = Decode(period_id, l_start_period_id, Nvl(comm_bonus.transaction_amount_ptd, 0),
775: Nvl(transaction_amount_itd,0) - Nvl(transaction_amount_ptd ,0)

Line 935: UPDATE cn_srp_period_quotas_all

931: l_advance_to_rec_itd := l_advance_to_rec_itd + period.advance_to_rec_ptd;
932: l_recovery_amount_itd :=l_recovery_amount_itd + period.recovery_amount_ptd ;
933: l_comm_pend_itd := l_comm_pend_itd + period.comm_pend_ptd;
934:
935: UPDATE cn_srp_period_quotas_all
936: SET
937: transaction_amount_itd = l_transaction_amount_itd,
938: commission_payed_itd = l_commission_payed_itd,
939: input_achieved_itd = l_input_achieved_itd,