DBA Data[Home] [Help]

APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on CN_SRP_PMT_PLANS

Line 612: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;

608:
609: l_quota_pay_element_rec quota_pay_element_rec_type := G_MISS_QUOTA_PAY_ELEMENT_REC;
610: l_qpe_row cn_quota_pay_elements%ROWTYPE ;
611:
612: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
613: l_role_id cn_srp_pmt_plans.role_id%TYPE;
614: l_start_date cn_srp_pmt_plans.start_date%TYPE;
615: l_end_date cn_srp_pmt_plans.end_date%TYPE;
616: l_action VARCHAR2(30) := 'CREATE';

Line 613: l_role_id cn_srp_pmt_plans.role_id%TYPE;

609: l_quota_pay_element_rec quota_pay_element_rec_type := G_MISS_QUOTA_PAY_ELEMENT_REC;
610: l_qpe_row cn_quota_pay_elements%ROWTYPE ;
611:
612: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
613: l_role_id cn_srp_pmt_plans.role_id%TYPE;
614: l_start_date cn_srp_pmt_plans.start_date%TYPE;
615: l_end_date cn_srp_pmt_plans.end_date%TYPE;
616: l_action VARCHAR2(30) := 'CREATE';
617:

Line 614: l_start_date cn_srp_pmt_plans.start_date%TYPE;

610: l_qpe_row cn_quota_pay_elements%ROWTYPE ;
611:
612: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
613: l_role_id cn_srp_pmt_plans.role_id%TYPE;
614: l_start_date cn_srp_pmt_plans.start_date%TYPE;
615: l_end_date cn_srp_pmt_plans.end_date%TYPE;
616: l_action VARCHAR2(30) := 'CREATE';
617:
618: BEGIN

Line 615: l_end_date cn_srp_pmt_plans.end_date%TYPE;

611:
612: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
613: l_role_id cn_srp_pmt_plans.role_id%TYPE;
614: l_start_date cn_srp_pmt_plans.start_date%TYPE;
615: l_end_date cn_srp_pmt_plans.end_date%TYPE;
616: l_action VARCHAR2(30) := 'CREATE';
617:
618: BEGIN
619: -- Standard Start of API savepoint