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_CALC_SUBLEDGER_PVT dependencies on CN_SRP_PAYEE_ASSIGNS_ALL

Line 113: cn_srp_payee_assigns_all spa,

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,
117: min(a.period_id) period_id,

Line 120: cn_srp_payee_assigns_all b

116: max(a.end_date) end_date,
117: min(a.period_id) period_id,
118: max(a.end_period_id) end_period_id
119: from cn_process_batches_all a,
120: cn_srp_payee_assigns_all b
121: where a.logical_batch_id = (select logical_batch_id
122: from cn_process_batches_all
123: where physical_batch_id = p_srp_subledger.physical_batch_id
124: and rownum = 1)

Line 155: cn_srp_payee_assigns_all spa,

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
159: where physical_batch_id = p_srp_subledger.physical_batch_id