eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_GET_COMM_PMT_PAID_GRP dependencies on CN_SRP_PERIODS

Line 148: p_org_id cn_srp_periods_all.org_id%TYPE)

144:
145: CURSOR get_comm_and_pmt(p_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE,
146: p_start_period_id cn_period_statuses_all.period_id%TYPE,
147: p_end_period_id cn_period_statuses_all.period_id%TYPE,
148: p_org_id cn_srp_periods_all.org_id%TYPE)
149: IS
150: SELECT NVL(SUM(NVL(balance2_dtd,0)),0) commission,
151: NVL(SUM(NVL(balance1_dtd,0) - NVL(balance1_ctd,0)),0) paid_pmt
152: FROM cn_srp_periods_all

Line 152: FROM cn_srp_periods_all

148: p_org_id cn_srp_periods_all.org_id%TYPE)
149: IS
150: SELECT NVL(SUM(NVL(balance2_dtd,0)),0) commission,
151: NVL(SUM(NVL(balance1_dtd,0) - NVL(balance1_ctd,0)),0) paid_pmt
152: FROM cn_srp_periods_all
153: WHERE salesrep_id = p_salesrep_id
154: AND period_id BETWEEN p_start_period_id AND p_end_period_id
155: AND credit_type_id = g_credit_type_id
156: AND quota_id IS NULL

Line 159: l_comp_earned cn_srp_periods.balance2_dtd%TYPE;

155: AND credit_type_id = g_credit_type_id
156: AND quota_id IS NULL
157: AND org_id = p_org_id;
158:
159: l_comp_earned cn_srp_periods.balance2_dtd%TYPE;
160: l_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE;
161: l_comp_paid cn_srp_periods.balance1_dtd%TYPE;
162: l_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE;
163:

Line 160: l_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE;

156: AND quota_id IS NULL
157: AND org_id = p_org_id;
158:
159: l_comp_earned cn_srp_periods.balance2_dtd%TYPE;
160: l_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE;
161: l_comp_paid cn_srp_periods.balance1_dtd%TYPE;
162: l_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE;
163:
164: l_sum_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE := 0;

Line 161: l_comp_paid cn_srp_periods.balance1_dtd%TYPE;

157: AND org_id = p_org_id;
158:
159: l_comp_earned cn_srp_periods.balance2_dtd%TYPE;
160: l_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE;
161: l_comp_paid cn_srp_periods.balance1_dtd%TYPE;
162: l_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE;
163:
164: l_sum_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE := 0;
165: l_sum_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE := 0;

Line 162: l_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE;

158:
159: l_comp_earned cn_srp_periods.balance2_dtd%TYPE;
160: l_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE;
161: l_comp_paid cn_srp_periods.balance1_dtd%TYPE;
162: l_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE;
163:
164: l_sum_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE := 0;
165: l_sum_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE := 0;
166: l_org_cnt NUMBER := 0;

Line 164: l_sum_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE := 0;

160: l_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE;
161: l_comp_paid cn_srp_periods.balance1_dtd%TYPE;
162: l_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE;
163:
164: l_sum_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE := 0;
165: l_sum_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE := 0;
166: l_org_cnt NUMBER := 0;
167: l_new_date_range_exists BOOLEAN := TRUE;
168:

Line 165: l_sum_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE := 0;

161: l_comp_paid cn_srp_periods.balance1_dtd%TYPE;
162: l_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE;
163:
164: l_sum_converted_comp_earned cn_srp_periods.balance2_dtd%TYPE := 0;
165: l_sum_converted_comp_paid cn_srp_periods.balance1_dtd%TYPE := 0;
166: l_org_cnt NUMBER := 0;
167: l_new_date_range_exists BOOLEAN := TRUE;
168:
169: l_proration_flag VARCHAR2(1);