APPS.CN_PMT_TRANS_PKG dependencies on CN_REPOSITORIES

Line 219: cn_repositories r

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
223: AND srp.credit_type_id = p_credit_type_id

Line 243: l_payroll_flag cn_repositories.payroll_flag%TYPE;

239:
240: l_held_amount NUMBER;
241: l_quota_id cn_payment_transactions.quota_id%TYPE;
242:
243: l_payroll_flag cn_repositories.payroll_flag%TYPE;
244: l_org_id cn_repositories.org_id%TYPE ;
245: l_status cn_salesreps.status%TYPE ;
246: l_period_set_id cn_repositories.period_set_id%TYPE ;
247: l_period_type_id cn_repositories.period_type_id%TYPE ;

Line 244: l_org_id cn_repositories.org_id%TYPE ;

240: l_held_amount NUMBER;
241: l_quota_id cn_payment_transactions.quota_id%TYPE;
242:
243: l_payroll_flag cn_repositories.payroll_flag%TYPE;
244: l_org_id cn_repositories.org_id%TYPE ;
245: l_status cn_salesreps.status%TYPE ;
246: l_period_set_id cn_repositories.period_set_id%TYPE ;
247: l_period_type_id cn_repositories.period_type_id%TYPE ;
248:

Line 246: l_period_set_id cn_repositories.period_set_id%TYPE ;

242:
243: l_payroll_flag cn_repositories.payroll_flag%TYPE;
244: l_org_id cn_repositories.org_id%TYPE ;
245: l_status cn_salesreps.status%TYPE ;
246: l_period_set_id cn_repositories.period_set_id%TYPE ;
247: l_period_type_id cn_repositories.period_type_id%TYPE ;
248:
249: BEGIN
250:

Line 247: l_period_type_id cn_repositories.period_type_id%TYPE ;

243: l_payroll_flag cn_repositories.payroll_flag%TYPE;
244: l_org_id cn_repositories.org_id%TYPE ;
245: l_status cn_salesreps.status%TYPE ;
246: l_period_set_id cn_repositories.period_set_id%TYPE ;
247: l_period_type_id cn_repositories.period_type_id%TYPE ;
248:
249: BEGIN
250:
251: SELECT s.org_id, s.status, r.period_set_id, r.period_type_id, NVL(r.payroll_flag,'N')

Line 253: FROM cn_salesreps s, cn_repositories_all r, cn_payruns_all pr

249: BEGIN
250:
251: SELECT s.org_id, s.status, r.period_set_id, r.period_type_id, NVL(r.payroll_flag,'N')
252: INTO l_org_id, l_status, l_period_set_id, l_period_type_id, l_payroll_flag
253: FROM cn_salesreps s, cn_repositories_all r, cn_payruns_all pr
254: WHERE s.salesrep_id = p_salesrep_id
255: AND s.org_id = r.org_id
256: AND pr.org_id = r.org_id
257: AND pr.payrun_id = p_payrun_id

Line 443: cn_repositories r

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
447: AND srp.quota_id = -1000