APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on CN_PAYMENT_WORKSHEETS

Line 31: FROM cn_payment_worksheets w,cn_payruns p

27: RAISE FND_API.G_EXC_ERROR;
28: END;
29: BEGIN
30: SELECT p.payrun_id,p.pay_period_id INTO x_payrun_id,x_period_id
31: FROM cn_payment_worksheets w,cn_payruns p
32: WHERE w.payment_worksheet_id = p_worksheet_id
33: AND p.payrun_id = w.payrun_id
34: --R12
35: AND p.org_id = w.org_id