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 609: FROM cn_srp_period_quotas_all spq

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

Line 703: UPDATE cn_srp_period_quotas_all

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

Line 769: UPDATE cn_srp_period_quotas_all

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

Line 933: UPDATE cn_srp_period_quotas_all

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