APPS.CSI_ORG_UNIT_VLD_PVT dependencies on CSI_I_ORG_ASSIGNMENTS_H

Line 213: FROM csi_i_org_assignments_h s,

209:
210: IF p_end_date < sysdate THEN
211: SELECT MAX(t.transaction_date)
212: INTO l_transaction_date
213: FROM csi_i_org_assignments_h s,
214: csi_transactions t
215: WHERE s.instance_ou_id=p_instance_ou_id
216: AND s.transaction_id=t.transaction_id
217: AND t.transaction_id <> p_txn_id;

Line 608: SELECT csi_i_org_assignments_h_s.nextval

604: IS
605: l_cis_i_org_assign_h_id NUMBER;
606:
607: BEGIN
608: SELECT csi_i_org_assignments_h_s.nextval
609: INTO l_cis_i_org_assign_h_id
610: FROM dual;
611: RETURN l_cis_i_org_assign_h_id;
612: EXCEPTION