DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on CSI_I_ORG_ASSIGNMENTS

Line 3877: FROM csi_i_org_assignments

3873: SELECT instance_ou_id,
3874: object_version_number
3875: INTO px_org_units_tbl(l_ind).instance_ou_id,
3876: px_org_units_tbl(l_ind).object_version_number
3877: FROM csi_i_org_assignments
3878: WHERE instance_id = px_org_units_tbl(l_ind).instance_id
3879: AND operating_unit_id = px_org_units_tbl(l_ind).operating_unit_id
3880: AND relationship_type_code = px_org_units_tbl(l_ind).relationship_type_code;
3881: EXCEPTION

Line 3889: FROM csi_i_org_assignments

3885: END;
3886: ELSE
3887: SELECT object_version_number
3888: INTO px_org_units_tbl(l_ind).instance_ou_id
3889: FROM csi_i_org_assignments
3890: WHERE instance_ou_id = px_org_units_tbl(l_ind).instance_ou_id;
3891: END IF;
3892: END LOOP;
3893: END IF;