APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_PAYMENT_WORKSHEETS_ALL

Line 85: UPDATE cn_payment_worksheets_all w

81: l_comm_ptd := 0 ;
82: l_bonus_ptd := 0 ;
83: END;
84:
85: UPDATE cn_payment_worksheets_all w
86: SET w.comm_ptd = l_comm_ptd,
87: w.bonus_ptd = l_bonus_ptd,
88: w.comm_due_bb = l_bb_earn
89: WHERE w.salesrep_id = p_salesrep_id

Line 2270: FROM cn_payment_worksheets_all cnpw

2266: AND cnp.org_id = cnspg.org_id
2267: AND cnp.org_id = cns.org_id
2268: AND ((cnspg.start_date <= cnps.end_date) AND (cnps.start_date <= nvl(cnspg.end_date, cnps.start_date)))
2269: AND NOT EXISTS (SELECT 1
2270: FROM cn_payment_worksheets_all cnpw
2271: WHERE cnpw.salesrep_id = cnspg.salesrep_id
2272: AND cnp.payrun_id = cnpw.payrun_id)
2273: AND (EXISTS (SELECT 1
2274: FROM cn_srp_payee_assigns cnspa

Line 4442: FROM cn_payment_worksheets_all wk

4438: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;
4439:
4440: SELECT wk.payment_worksheet_id,wk.object_version_number
4441: INTO l_worksheet_rec.worksheet_id,l_ovn
4442: FROM cn_payment_worksheets_all wk
4443: WHERE wk.payrun_id = l_worksheet_rec.payrun_id
4444: AND wk.salesrep_id = l_worksheet_rec.salesrep_id
4445: AND quota_id IS NULL;
4446: