APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_PAYMENT_WORKSHEETS_ALL

Line 87: UPDATE cn_payment_worksheets_all w

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

Line 2227: FROM cn_payment_worksheets_all cnpw

2223: AND cnp.org_id = cnspg.org_id
2224: AND cnp.org_id = cns.org_id
2225: AND ((cnspg.start_date <= cnps.end_date) AND (cnps.start_date <= nvl(cnspg.end_date, cnps.start_date)))
2226: AND NOT EXISTS (SELECT 1
2227: FROM cn_payment_worksheets_all cnpw
2228: WHERE cnpw.salesrep_id = cnspg.salesrep_id
2229: AND cnp.payrun_id = cnpw.payrun_id)
2230: AND (EXISTS (SELECT 1
2231: FROM cn_srp_payee_assigns cnspa

Line 2312: FROM cn_payment_worksheets_all cnpw

2308: AND cnp.org_id = cnspg.org_id
2309: AND cnp.org_id = cns.org_id
2310: AND ((cnspg.start_date <= cnps.end_date) AND (cnps.start_date <= nvl(cnspg.end_date, cnps.start_date)))
2311: AND NOT EXISTS (SELECT 1
2312: FROM cn_payment_worksheets_all cnpw
2313: WHERE cnpw.salesrep_id = cnspg.salesrep_id
2314: AND cnp.payrun_id = cnpw.payrun_id)
2315: AND (EXISTS (SELECT 1
2316: FROM cn_srp_payee_assigns cnspa

Line 4509: FROM cn_payment_worksheets_all wk

4505: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;
4506:
4507: SELECT wk.payment_worksheet_id,wk.object_version_number
4508: INTO l_worksheet_rec.worksheet_id,l_ovn
4509: FROM cn_payment_worksheets_all wk
4510: WHERE wk.payrun_id = l_worksheet_rec.payrun_id
4511: AND wk.salesrep_id = l_worksheet_rec.salesrep_id
4512: AND quota_id IS NULL;
4513: