[Home] [Help]
APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SRP_PERIODS_ALL
Line 33: FROM cn_srp_periods_all s,
29: SELECT SUM(nvl(balance2_bbd, 0) - nvl(balance2_bbc, 0)) prior_earning,
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