APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_SRP_PERIODS_ALL

Line 112: from cn_srp_periods_all sp,

108:
109: cursor payees_cr is
110: select sp.srp_period_id,
111: nvl(sum(cl.commission_amount),0) comm_earned_ptd
112: from cn_srp_periods_all sp,
113: cn_srp_payee_assigns_all spa,
114: (select b.payee_id,
115: min(a.start_date) start_date,
116: max(a.end_date) end_date,

Line 154: from cn_srp_periods_all sp,

150: group by sp.srp_period_id;
151:
152: cursor sync_recs_cr is
153: select sp.salesrep_id, sp.credit_type_id, min(sp.period_id) period_id
154: from cn_srp_periods_all sp,
155: cn_srp_payee_assigns_all spa,
156: cn_process_batches_all pb
157: where pb.logical_batch_id = (select logical_batch_id
158: from cn_process_batches_all

Line 184: FROM cn_srp_periods_all

180: period_id,
181: end_date,
182: Nvl(balance3_ctd,0) earnings_ptd,
183: Nvl(balance2_dtd,0) earnings_due_ptd
184: FROM cn_srp_periods_all
185: WHERE salesrep_id = l_salesrep_id
186: AND org_id = g_org_id
187: AND period_id between p_start_period_id and p_end_period_id
188: AND start_date <= l_end_date

Line 200: FROM cn_srp_periods_all

196: l_subledger subledger_cr%ROWTYPE;
197:
198: CURSOR get_distinct_roles IS
199: SELECT distinct role_id, credit_type_id
200: FROM cn_srp_periods_all
201: WHERE salesrep_id = l_salesrep_id
202: AND org_id = g_org_id
203: AND (((start_date <= l_start_date)
204: AND( end_date >= l_start_date))

Line 404: update cn_srp_periods_all

400: close end_calc;
401:
402: if (l_dummy = 1) then
403: for payee in payees_cr loop
404: update cn_srp_periods_all
405: set balance2_dtd = payee.comm_earned_ptd,
406: balance3_ctd = payee.comm_earned_ptd
407: where srp_period_id = payee.srp_period_id;
408: end loop;