DBA Data[Home] [Help]

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_PAYRUNS_ALL

Line 36: cn_payruns_all pr

32: INTO l_bb_earn,
33: l_bb_pmt_recover,
34: l_bb4_begin
35: FROM cn_srp_periods_all s,
36: cn_payruns_all pr
37: WHERE s.salesrep_id = p_salesrep_id
38: AND s.org_id = pr.org_id
39: AND pr.payrun_id = p_payrun_id
40: AND s.quota_id IS NULL

Line 70: cn_payruns_all pr

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

Line 2498: cn_payruns_all pr

2494: l_payroll_flag,
2495: l_payables_flag
2496: FROM cn_salesreps s,
2497: cn_repositories_all r,
2498: cn_payruns_all pr
2499: WHERE s.salesrep_id = wksht_rec.salesrep_id
2500: AND s.org_id = r.org_id
2501: AND pr.org_id = r.org_id
2502: AND pr.payrun_id = wksht_rec.payrun_id;