APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on CN_PAY_APPROVAL_FLOW_S

Line 123: SELECT cn_pay_approval_flow_s.NEXTVAL

119: WHERE payrun_id = p_payrun_id;
120:
121: IF cn_payment_security_pvt.is_superuser(p_period_id => p_period_id,p_org_id=>p_org_id) = 1 THEN
122: -- insert record into cn_pay_approval_flow
123: SELECT cn_pay_approval_flow_s.NEXTVAL
124: INTO l_flow_rec.pay_approval_flow_id FROM dual;
125: l_flow_rec.payrun_id := p_payrun_id;
126: l_flow_rec.payment_worksheet_id := p_worksheet_id;
127: l_flow_rec.submit_by_resource_id := p_resource_id ;

Line 142: SELECT cn_pay_approval_flow_s.NEXTVAL

138: ( p_pay_approval_flow_rec => l_flow_rec);
139: ELSE
140: FOR l_mgr_csr IN c_mgr_csr(p_org_id) LOOP
141: -- insert record into cn_pay_approval_flow
142: SELECT cn_pay_approval_flow_s.NEXTVAL
143: INTO l_flow_rec.pay_approval_flow_id FROM dual;
144: l_flow_rec.payrun_id := p_payrun_id;
145: l_flow_rec.payment_worksheet_id := p_worksheet_id;
146: l_flow_rec.submit_by_resource_id := p_resource_id ;