APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on DUAL

Line 124: INTO l_flow_rec.pay_approval_flow_id FROM dual;

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 ;
128: l_flow_rec.submit_by_user_id := fnd_global.user_id;

Line 143: INTO l_flow_rec.pay_approval_flow_id FROM dual;

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 ;
147: l_flow_rec.submit_by_user_id := fnd_global.user_id;