APPS.CN_PMT_TRANS_PKG dependencies on CN_RS_SALESREPS

Line 218: cn_rs_salesreps s,

214: DECODE (r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id
215: FROM cn_srp_periods srp,
216: cn_quotas_all q,
217: cn_quota_pay_elements_all qp,
218: cn_rs_salesreps s,
219: cn_repositories r
220: WHERE srp.salesrep_id = p_salesrep_id
221: AND srp.period_id = p_pay_period_id
222: AND srp.quota_id = q.quota_id

Line 442: cn_rs_salesreps s,

438: srp.org_id,
439: 1
440: FROM cn_srp_periods srp,
441: cn_quota_pay_elements_all qp,
442: cn_rs_salesreps s,
443: cn_repositories r
444: WHERE srp.salesrep_id = p_salesrep_id
445: AND srp.period_id = p_pay_period_id
446: AND srp.credit_type_id = p_credit_type_id