APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_PAYRUNS_ALL

Line 34: cn_payruns_all pr

30: - (SUM(nvl(balance4_bbd, 0) - nvl(balance4_bbc, 0))) - (SUM(nvl(balance4_dtd, 0) - nvl(balance4_ctd, 0)))
31: INTO l_bb_earn,
32: l_bb_pmt_recover
33: FROM cn_srp_periods_all s,
34: cn_payruns_all pr
35: WHERE s.salesrep_id = p_salesrep_id
36: AND s.org_id = pr.org_id
37: AND pr.payrun_id = p_payrun_id
38: AND s.quota_id IS NULL

Line 68: cn_payruns_all pr

64: INTO l_bonus_ptd,
65: l_comm_ptd
66: FROM cn_srp_period_quotas_all cspq,
67: cn_quotas_all quota,
68: cn_payruns_all pr
69: WHERE cspq.quota_id = quota.quota_id
70: AND quota.quota_id > 0
71: AND quota.org_id = cspq.org_id
72: AND pr.pay_period_id = cspq.period_id

Line 2452: cn_payruns_all pr

2448: l_payroll_flag,
2449: l_payables_flag
2450: FROM cn_salesreps s,
2451: cn_repositories_all r,
2452: cn_payruns_all pr
2453: WHERE s.salesrep_id = wksht_rec.salesrep_id
2454: AND s.org_id = r.org_id
2455: AND pr.org_id = r.org_id
2456: AND pr.payrun_id = wksht_rec.payrun_id;