APPS.CN_PMT_TRANS_PKG dependencies on CN_SRP_PERIODS

Line 191: -- cn_srp_periods

187: -- we need need to check the pay by transaction value
188: -- if the value is N we need to insert the record from
189: -- cn_commission_lines
190: -- if the value is Y then we need to insert from
191: -- cn_srp_periods
192: -- for all Quota ID and the Null QUOTA ID
193: -- Called from : cnvwkshb.pls ( Worksheet Creation )
194: --============================================================================
195: PROCEDURE INSERT_RECORD (

Line 215: FROM cn_srp_periods srp,

211: IS
212: SELECT DISTINCT q.quota_id,
213: q.incentive_type_code,
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

Line 357: FROM cn_srp_periods srp

353: srp.quota_id,
354: each_quota.pay_element_type_id pay_element_type_id,
355: --R12
356: srp.org_id
357: FROM cn_srp_periods srp
358: WHERE srp.salesrep_id = p_salesrep_id
359: AND srp.period_id = p_pay_period_id
360: AND srp.quota_id = each_quota.quota_id
361: AND srp.quota_id <> -1000

Line 440: FROM cn_srp_periods srp,

436: --Bug 3080846 for who columns
437: g_last_update_login,--Bug 3080846 for who columns
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